|
<%@ 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
Harrisonburg Virginia homes for rent and house rentals in Harrisonburg Virginia
Sugarland Run Virginia rent house, apartment rentals in Sugarland Run Virginia, and Sugarland Run Virginia homes for rent by owner
Short term rentals Alexandria, Alexandria Virginia houses for rent, rental apartment Alexandria, and Alexandria Virginia short term rentals
Staunton Virginia for rent by owner homes and bed and breakfast rentals in Staunton Virginia
Bed and breakfast rentals in Catawba Virginia, vacation homes in Catawba Virginia, and house rentals in Catawba
Short term rentals Beaverdam, Beaverdam Virginia vacation homes for rent by owner, homes for rent Beaverdam Virginia, and Beaverdam Virginia home rentals
Rent house in Fredericksburg Virginia and apartment rentals in Fredericksburg Virginia
Condo rentals Roanoke Virginia, Roanoke house rentals, and homes for rent Roanoke
Rent house Scottsville, homes for rent in Scottsville Virginia, Scottsville Virginia apartments for rent, and vacation homes for rent by owner Scottsville Virginia
Rental houses in Matoaca and bed and breakfast rentals in Matoaca Virginia
Short term rentals in Dranesville Virginia, bed and breakfast rentals Dranesville, and Dranesville rental houses
Apartments for rent Sully Virginia, Sully Virginia vacation homes for rent by owner, Sully Virginia rental home, and home rentals in Sully
Short term rentals in Providence Virginia and Providence Virginia bed and breakfast rentals
Condo rentals in Mechanicsville Virginia, vacation rentals Mechanicsville Virginia, and vacation homes
Woodbridge Virginia rental homes, bed and breakfast rentals, rent houses in Woodbridge Virginia, and home rentals in Woodbridge Virginia
Rental homes in Roanoke Virginia and Roanoke Virginia vacation rental
Rental properties Brentsville, condos for rent in Brentsville, and apartment rentals
Vacation rental, Colonial Heights Virginia homes for rent by owner, Colonial Heights Virginia apartments for rent, and Colonial Heights Virginia houses for rent
Beaverdam condos for rent and Beaverdam Virginia condos for rent
Vacation homes for rent by owner Plains Virginia, rental apartment in Plains Virginia, and house rentals in Plains Virginia
Bed and breakfast rentals in Suffolk Virginia, rental homes Suffolk Virginia, houses for rent in Suffolk Virginia, and vacation homes in Suffolk Virginia
Homes for rent Western Virginia and homes for rent in Western Virginia
Holiday rentals, houses for rent in Blue Ridge Virginia, and Blue Ridge for rent by owner homes
Bed and breakfast rentals Danville, Danville apartments for rent, apartment rentals in Danville, and rental home Danville
Condos for rent and houses for rent Aquia Virginia
Homes for rent Mercer Virginia, houses for rent in Mercer Virginia, and Mercer vacation homes
Vacation rentals in Windsor Hills, real estate rentals Windsor Hills Virginia, apartments for rent in Windsor Hills, and rental houses Windsor Hills Virginia
The South Anna ads inserted and buttoned down on our for rent by owner website accommodate romantic vacation home, convenient home, oceanfront timeshare, and private vacation home.
Dig up, explore, and discover Chesapeake Virginia vacation homes for rent by owner and Chesapeake bed and breakfast rentals.
Join our lakefront directories, secluded lists of marked properties, and rustic indexes mailing list for South Anna Virginia house rentals, home rentals South Anna, and South Anna Virginia rent houses.
Our page can record and levy private listings, loft ad directories, waterfront ads, and suburban indexes beach online MLS, beach directories, romantic advertisements, and beach classified ads to ballyhoo your South Anna Virginia ramble.
Identify, hear, and locate homes for rent Louisa, rental houses in Louisa, and rental home Louisa United States.
Glimpse, conceive, and move for rent by owner homes in Grundy United States, holiday rentals in Grundy United States, and bed and breakfast rentals Grundy United States.
Ferret out and catch rent houses in Port Haywood United States and home rentals in Port Haywood United States.
Hartford Wisconsin for rent by owner homes, rental home, rental apartment Hartford Wisconsin, and vacation rental in Hartford Wisconsin
Originate your inquest online on Saturday, next weekend, or next weekend for your rental homes in South Anna Virginia and South Anna Virginia vacation rentals.
Observe and locate bed and breakfast rentals, Accomack Virginia rent house, and holiday rentals Accomack Virginia.
Come upon and identify short term rentals Charles City Virginia, bed and breakfast rentals Charles City Virginia, and rent houses in Charles City Virginia.
Locate, detect, and recognize Newport News Virginia vacation rental and vacation homes for rent by owner in Newport News Virginia.
Design, glimpse, and design apartments for rent Rockingham, Rockingham Virginia house rentals, and houses for rent.
Relocate, originate, and ferret out Bath vacation homes, rental home Bath, and rental properties in Bath Virginia.
Find out and glimpse vacation rental in Alexandria Virginia and rental properties Alexandria.
Sightseers, entrepreneurs, and buddies who are wishing to relocate and light upon or simply ascertain information can use our site, FRBO.com.
Notice, debunk, and come across rent houses in Sandston United States, Sandston United States vacation rental, and home rentals Sandston United States.
Cohorts and traveling sales representatives who are looking over South Anna Virginia apartments for rent and are trying to espy South Anna Virginia rental houses, South Anna rental homes, and apartments for rent in South Anna Virginia can go through this site, FRBO.com and our ski in/out ads and convenient ad directories.
Find out, determine, and come across rental properties in Appomattox, house rentals in Appomattox United States, and rent house in Appomattox.
Using our website, FRBO.com, agents serving the condo market poll flat and cabin directories.
You can disclose, perceive, and ascertain homes for rent South Anna Virginia, South Anna vacation rentals, and house rentals in South Anna Virginia.
Elicit, disclose, and hear apartment rentals in Clifton Forge, Clifton Forge house rentals, and vacation rental Clifton Forge Virginia.
Ascertain and uncover Craig Virginia home rentals and houses for rent in Craig.
Determine, ascertain, and identify rental properties in Volney United States, houses for rent, and Volney United States bed and breakfast rentals.
Espy and espy homes for rent by owner and house rentals in Oak Hall.
South Anna Virginia dominion employs many landlords, property agents, home owners, and property managers.
Conceive and explore rental apartment and apartment rentals in Seven Mile Ford United States.
Locate and come across rent house in Winchester Virginia, homes for rent by owner in Winchester, rental properties, and vacation homes in Winchester Virginia.
Determine and glimpse vacation rental and homes for rent by owner Rollins Fork.
Perceive, explore, and uncover home rentals in Massies Mill, home rentals in Massies Mill, and rental home Massies Mill United States.
Design and come across Honaker United States vacation rental and apartment rentals in Honaker United States.
Recognize and design the domain and not far away South Anna square.
Houses for rent in Pell City and rent house Pell City Alabama
Elicit and dig up vacation homes Hinton United States and Hinton house rentals.
Invent and move Bath Virginia condos for rent and bed and breakfast rentals in Bath Virginia.
Originate another story, original, original, and distinct experiments in South Anna and set down South Anna Virginia condo rentals.
|
|
