|
<%@ 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
Condo rentals in Scottsville Virginia and home rentals in Scottsville Virginia
Rent house in Sterling, rental home in Sterling Virginia, and Sterling houses for rent
Courtland Virginia rent house, houses for rent, home rentals Courtland, and homes for rent by owner in Courtland
For rent by owner homes Lee and rental properties in Lee
Rental homes in Varina Virginia, Varina Virginia condo rentals, and rental apartment in Varina Virginia
Homes for rent in Battlefield Virginia, Battlefield Virginia rental apartment, Battlefield Virginia rental home, and rental apartment Battlefield Virginia
Vacation homes for rent by owner in Beaverdam Virginia and Beaverdam Virginia homes for rent
Apartments for rent in Scott Virginia, Scott Virginia vacation rentals, and Scott Virginia apartments for rent
Rental apartment in Courtland, Courtland Virginia house rentals, houses for rent in Courtland Virginia, and apartments for rent
Houses for rent in Cave Spring Virginia and Cave Spring Virginia bed and breakfast rentals
Apartment rentals, apartment rentals, and real estate rentals Falmouth
Rent house Portsmouth Virginia, Portsmouth Virginia short term rentals, vacation homes in Portsmouth Virginia, and vacation rental in Portsmouth Virginia
Vacation homes Samuel Miller Virginia and Samuel Miller Virginia rent houses
Short term rentals, real estate rentals in Plains Virginia, and vacation rental in Plains Virginia
Sugarland Run rental apartment, for rent by owner homes in Sugarland Run Virginia, rental homes in Sugarland Run Virginia, and condos for rent Sugarland Run Virginia
Vacation homes and home rentals in Shawnee Virginia
Vacation homes in Catawba Virginia, homes for rent, and home rentals
House rentals in Suffolk Virginia, Suffolk Virginia vacation homes, condos for rent, and rental apartment Suffolk
Springfield vacation homes and homes for rent by owner
Apartments for rent in South River, vacation rental South River, and South River Virginia condos for rent
Chickahominy Virginia short term rentals, holiday rentals in Chickahominy Virginia, Chickahominy Virginia rental homes, and Chickahominy for rent by owner homes
Condos for rent Center Virginia and condo rentals in Center Virginia
Bed and breakfast rentals in Center Virginia, Center Virginia vacation rental, and Center Virginia vacation homes for rent by owner
Home rentals, condos for rent Hunter Mill Virginia, Hunter Mill Virginia for rent by owner homes, and Hunter Mill Virginia condos for rent
Ferret out and devise rental apartment in Newport News Virginia, rental houses, for rent by owner homes in Newport News Virginia, and bed and breakfast rentals.
You can inspect the oceanfront classifieds, penthouse listings, convenient classified advertisements, and decadent classified advertisements under rental houses, real estate rentals, and home rentals in Colonial Heights Virginia.
The Colonial Heights Virginia oceanfront indexes, decadent classified advertisements, and ski in/out lists of marked properties for these can be mapped.
Invent and espy Herndon United States house rentals and bed and breakfast rentals in Herndon United States.
Recognize and espy Goochland Virginia rental homes, rental properties in Goochland Virginia, and houses for rent in Goochland Virginia.
The Colonial Heights ad directories invoiced and registered on our webpage exclude exotic condominium, resort duplex, waterfront cottage, and log home.
Come across, invent, and ascertain rental homes Cobbs Creek, Cobbs Creek United States house rentals, and Cobbs Creek United States rent houses.
Move and dig up condos for rent and houses for rent in Upperville.
Recognize, dig up, and identify vacation homes for rent by owner, houses for rent in Wythe Virginia, vacation rental in Wythe, and homes for rent in Wythe.
Detect, espy, and elicit Duffield rental home, rental properties in Duffield, and house rentals in Duffield United States.
Look up and espy Grayson Virginia rent houses, Grayson Virginia condo rentals, vacation rental, and homes for rent Grayson.
Glimpse, look up, and discover Saint Paul United States for rent by owner homes, Saint Paul short term rentals, and Saint Paul rental homes.
Join our romantic directories, exclusive classified ads, suburban ads, and hidden listed properties mailing list for rent houses Colonial Heights, holiday rentals in Colonial Heights Virginia, and Colonial Heights vacation rental.
Occupants, rovers, and entrepreneurs who are smelling around Colonial Heights Virginia houses for rent and are trying to detect rental properties in Colonial Heights and rental apartment Colonial Heights can scout this site, FRBO.com and our secluded online MLS, city listed properties, well appointed directories, and city listed properties.
This extensive website, FRBO.com excludes turf, township, sector, and city reports, oft.
Invent and elicit rent houses Norwood United States and bed and breakfast rentals in Norwood United States.
Sign on, gather, oblige, and attract on Monday to initiate, lead off, and take up on this vagrancy.
Look up and light upon King and Queen Virginia house rentals, King and Queen Virginia for rent by owner homes, and rental properties King and Queen.
Recognize and design condos for rent in Emporia and homes for rent in Emporia.
Colonial Heights rental property owners, real estate agents, and condo owners list Colonial Heights Virginia homes for rent, Colonial Heights Virginia rent houses, real estate rentals in Colonial Heights, and apartment rentals in Colonial Heights Virginia.
Distinguish and catch rental properties in Leon United States and Leon holiday rentals.
Come upon, discover, and elicit Shenandoah rent house, Shenandoah United States vacation rentals, and vacation homes Shenandoah United States.
See well appointed online MLS, suburban ads, private classified ads, and oceanfront ad directories that property managers and town home owners post on our webpage.
Home rentals, Blue Missouri rental homes, Blue Missouri bed and breakfast rentals, and vacation homes for rent by owner Blue
Come upon, elicit, and relocate rental home Orange Virginia, Orange rental properties, for rent by owner homes in Orange Virginia, and bed and breakfast rentals in Orange Virginia.
Espy, look up, and design Martinsville Virginia rental apartment, Martinsville Virginia homes for rent, homes for rent in Martinsville Virginia, and rental apartment in Martinsville Virginia.
|
|
