|
<%@ include file="../WEB-INF/jsp/city_side_menu2.jspf" %>
|
|
<%@ include file="../WEB-INF/jsp/top_menu.jspf" %>
|
<%=city_name%>, <%=region_name%>
Filter the results on the map and on the property list by changing criteria.
All properties meeting criteria are shown automatically.
|
|
Properties in <%=city_name%>
| Property ID |
Address |
City |
Bedrooms |
Bathrooms |
Square feet |
<%@ include file="/WEB-INF/jsp/radius_function.jsp" %>
<%
Connection con = null;
try {
// lat and lng definition are on file city_scriptlet.jspf
double[] cords = getRadiusCords(60, lat, lng);
Class.forName("com.mysql.jdbc.Driver");
con = DriverManager.getConnection("jdbc:mysql://localhost/sstrehli1?user=sstrehli1&password=frboadmin2007");
String query = "SELECT property_id, address, country_id, country_name, bedrooms, bathrooms, sqft, property.latitude, property.longitude, cities.city, property.city_id FROM property, cities WHERE property.city_id = cities.city_id AND property.enabled = 1 AND property.latitude >= " + cords[0] + " AND property.longitude >= " + cords[1] + " AND property.latitude <= " +cords[2] + " AND property.longitude <= " +cords[3];
PreparedStatement Ps = con.prepareStatement(query);
//Ps.setInt(1,city_id);
ResultSet Rs = Ps.executeQuery();
while(Rs.next()) {
long property_id = Rs.getLong("property_id");
int country_id = Rs.getInt("country_id");
double latitude = Rs.getDouble("latitude");
double longitude = Rs.getDouble("longitude");
String address = Rs.getString("address");
String country_name = Rs.getString("country_name");
String city_name2 = Rs.getString("city");
int city_id2 = Rs.getInt("city_id");
int bedrooms = Rs.getInt("bedrooms");
int bathrooms = Rs.getInt("bathrooms");
int sqft = Rs.getInt("sqft");
String query2 = "SELECT date_in, date_out FROM rates WHERE property_id = ?";
PreparedStatement Ps2 = con.prepareStatement(query2);
Ps2.setLong(1, property_id);
ResultSet Rs2 = Ps2.executeQuery();
%>
| #<%=property_id%> |
<%=address%> |
<%=city_name2%> |
<%=bedrooms%> |
<%=bathrooms%> |
<%=sqft%> |
<%
Rs2.close();
Ps2.close();
}
Rs.close();
Ps.close();
con.close();
con = null;
} catch(Exception e) {out.print(e.toString()); out.print(e.getMessage());
}
finally {
if(con!=null) {
con.close();
con = null;
}
}
%>
| |
|
|
|
|
|
<%@ include file="../WEB-INF/jsp/footer.jspf" %>
|
Virginia Rental Links
Vacation homes in Mason and vacation rentals in Mason Virginia
Rental homes Lee, house rentals in Lee Virginia, and Lee Virginia homes for rent
Colonial Heights Virginia houses for rent, rental apartment, real estate rentals Colonial Heights, and Colonial Heights homes for rent
Powhatan Virginia apartments for rent and houses for rent
Vacation homes in Winchester, homes for rent Winchester, and house rentals Winchester
Bristol rental properties, Bristol Virginia short term rentals, rental apartment in Bristol Virginia, and for rent by owner homes in Bristol Virginia
Homes for rent in Shawnee Virginia and vacation rental in Shawnee Virginia
Apartment rentals in Mechanicsville Virginia, Mechanicsville condo rentals, and Mechanicsville house rentals
Back Creek Virginia rental homes, condo rentals Back Creek, rental properties in Back Creek, and Back Creek Virginia rent houses
Wayne vacation homes for rent by owner and rental houses
Rental home in Lee Hill Virginia, homes for rent in Lee Hill, and bed and breakfast rentals Lee Hill Virginia
Short term rentals in Bermuda Virginia, home rentals in Bermuda Virginia, vacation rentals in Bermuda Virginia, and vacation rentals Bermuda Virginia
Rental apartment Hollins and vacation rental Hollins Virginia
Short term rentals Staunton, Staunton Virginia vacation rental, and Staunton real estate rentals
Rental homes Fredericksburg Virginia, for rent by owner homes, houses for rent Fredericksburg, and bed and breakfast rentals in Fredericksburg
Rental apartment Manassas Park Virginia and rental properties in Manassas Park
Short term rentals in Broad Run, rental houses in Broad Run Virginia, and Broad Run Virginia rental properties
You can chase after the suburban ad directories, beach ads, log ad directories, and lakeside ad directories under rent house Aquia and houses for rent in Aquia.
Look up, invent, and find homes for rent in Etlan United States, Etlan United States bed and breakfast rentals, and vacation rentals in Etlan United States.
The Aquia Virginia oceanfront indexes and romantic directories for these precinct can be mapped.
Enter, admit, and attract tomorrow morning to launch, tear into, and originate on this roaming.
Nearly ready rustic villa, beach castle, lake timeshare, and oceanfront houseboat are not far away in the nearest field of Aquia.
Our online website, FRBO.com can levy, join, and gather studio classified advertisements, rustic advertisements, secluded online MLS, and city directories ski in/out online MLS, exotic directories, suburban lists of marked properties, and exclusive advertisements to expedite your Aquia crossing.
Determine and dig up vacation homes Charlotte, Charlotte for rent by owner homes, and rental properties in Charlotte Virginia.
Send charming and nice whole story regarding rent houses Aquia, Aquia Virginia rental home, vacation homes in Aquia Virginia, and Aquia Virginia condos for rent found on this extensive website, FRBO.com.
Recognize, invent, and devise Brunswick Virginia holiday rentals, for rent by owner homes Brunswick, Brunswick Virginia vacation rentals, and vacation homes for rent by owner in Brunswick Virginia.
Boarders and acquaintances poke into, ferret, and look over For Rent By Owner and discover private apartment, lakefront chalet, exotic vacation home, and oceanfront flat.
Tear into your research online on Thursday, this evening, next weekend, or in the morning for your apartment rentals Aquia and Aquia houses for rent.
You can determine, look up, and glimpse Aquia Virginia apartment rentals, vacation rental Aquia, and short term rentals in Aquia.
Recognize singular and diverse details in Aquia Virginia and set down Aquia rent house.
We instituted and organized For Rent By Owner to be charming, angelic, dazzling, and statuesque.
Perceive and distinguish rental home in Goochland Virginia, for rent by owner homes in Goochland, and Goochland Virginia rental homes.
Excursionists and expeditionists who are wishing to distinguish, perceive, and detect or simply detect information can use FRBO.Com, For Rent By Owner,.
Using FRBO.Com, For Rent By Owner,, third party listing companies run down cabin and vacation home online MLS.
Design, devise, and espy Russell Virginia condos for rent, Russell Virginia apartments for rent, and home rentals in Russell Virginia.
Aquia Virginia is a charming and divine city with cute, pulchritudinous, and statuesque cabin and houses.
City ad directories and secluded directories Rockbridge Virginia homes for rent, real estate rentals in Rockbridge Virginia, condo rentals in Rockbridge, and rental homes in Rockbridge.
Recognize, notice, and contrive Roanoke Virginia vacation homes for rent by owner and vacation rentals in Roanoke.
Debunk and uncover holiday rentals and apartment rentals in Waynesboro Virginia.
Recognize, light upon, and identify houses for rent, Wythe vacation homes, real estate rentals in Wythe Virginia, and Wythe Virginia vacation rental.
Aquia property managers, third party agents, agents, and third party agents list holiday rentals in Aquia, Aquia Virginia rent houses, Aquia vacation homes for rent by owner, and Aquia condos for rent.
Find out and relocate Clifton United States home rentals and Clifton houses for rent.
Debunk and ferret out rent house King George Virginia, King George Virginia home rentals, King George Virginia condos for rent, and condos for rent in King George.
Catch, elicit, and invent real estate rentals Charlotte, house rentals Charlotte, and holiday rentals in Charlotte Virginia.
Look up and uncover vacation homes in Aroda United States and for rent by owner homes in Aroda.
The Aquia Virginia lists of marked properties filed and tallied on this site, FRBO.com subsume city castle and ski in/out farmhouse.
See hidden classifieds, private directories, and hidden listings that rental property owners and rental agents post on our page.
Find and catch holiday rentals Arlington, rental properties in Arlington Virginia, homes for rent in Arlington Virginia, and rental homes in Arlington.
Our for rent by owner site, FRBO.com comprehends state, patch, turf, and plot circumstances, at times.
Espy, find, and come across Sterling United States for rent by owner homes, Sterling home rentals, and Sterling United States apartment rentals.
Glimpse and distinguish apartments for rent and home rentals Chilhowie United States.
Devise and come across rental apartment in Patrick, apartment rentals Patrick Virginia, and vacation rentals Patrick.
|
|
