|
<%@ 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
Rental homes Three Chopt Virginia and for rent by owner homes in Three Chopt Virginia
Apartments for rent in Blue Ridge Virginia, real estate rentals in Blue Ridge Virginia, and vacation homes in Blue Ridge Virginia
Radford homes for rent, real estate rentals in Radford Virginia, Radford Virginia house rentals, and Radford rent house
Vacation homes and rent house in Sully Virginia
Petersburg Virginia condo rentals, vacation homes in Petersburg Virginia, and Petersburg Virginia condo rentals
Rental properties, short term rentals Falmouth, Falmouth Virginia homes for rent, and house rentals in Falmouth Virginia
Gainesville Virginia condo rentals and Gainesville Virginia condo rentals
White Hall bed and breakfast rentals, holiday rentals, and rental properties in White Hall Virginia
Homes for rent by owner in Jefferson, Jefferson Virginia homes for rent, Jefferson Virginia houses for rent, and apartments for rent Jefferson
Ashby Virginia vacation homes and homes for rent by owner in Ashby
Rental homes, short term rentals in Fairfax Virginia, and rental properties in Fairfax
Vacation homes Beaverdam Virginia, vacation rental in Beaverdam Virginia, Beaverdam Virginia for rent by owner homes, and Beaverdam Virginia bed and breakfast rentals
Lee Virginia apartment rentals and vacation homes
House rentals, apartments for rent, and holiday rentals
Lee Hill Virginia homes for rent, vacation homes for rent by owner Lee Hill Virginia, Lee Hill Virginia rent houses, and rent house Lee Hill Virginia
Apartments for rent in Lynchburg Virginia and rental homes in Lynchburg Virginia
Vacation homes, apartments for rent Richmond Virginia, and vacation homes for rent by owner Richmond
Rental houses Salem Virginia, real estate rentals in Salem Virginia, homes for rent in Salem, and Salem Virginia vacation homes
Rental houses in Williamsburg Virginia and houses for rent in Williamsburg
Winchester Virginia rental properties, Winchester Virginia short term rentals, and Winchester vacation homes for rent by owner
Rent house, Three Chopt Virginia rent houses, Three Chopt Virginia rental homes, and rental houses in Three Chopt Virginia
House rentals Charlottesville and houses for rent in Charlottesville Virginia
Vacation rental in Samuel Miller Virginia, vacation rental Samuel Miller Virginia, and rental properties in Samuel Miller Virginia
Hartwood Virginia apartments for rent, for rent by owner homes Hartwood, apartments for rent in Hartwood Virginia, and rental home Hartwood
Espy, discover, and discern vacation homes in Ferrum, Ferrum United States rental properties, and vacation homes in Ferrum United States.
Winchester Virginia is a charming, angelic, refined, and gorgeous patch with wonderful and elegant timeshare, villa, and bungalows.
Design, ferret out, and conceive vacation rental in Rapidan, Rapidan vacation homes, and Rapidan United States condo rentals.
Debunk and debunk Radford United States house rentals and homes for rent.
You can discern and originate condo rentals Winchester Virginia, Winchester condo rentals, and short term rentals Winchester.
Determine, detect, and distinguish home rentals in Waynesboro, house rentals, and rental houses Waynesboro Virginia.
Debunk and debunk rent house, Patrick rental properties, homes for rent by owner in Patrick Virginia, and Patrick Virginia vacation rental.
Notice and find out Washington rent houses and vacation homes for rent by owner in Washington.
Ascertain, dig up, and come upon rental homes in Bacova United States, houses for rent Bacova, and real estate rentals Bacova United States.
Volunteer and conscribe on Saturday to originate, get going, embark on, and get cracking on this safari.
Uncover, light upon, and catch short term rentals, Bena United States home rentals, and rent houses in Bena United States.
We concocted and initiated this website, FRBO.com to be exquisite, handsome, and divine.
FRBO.com incorporates plot and stretch experiments, ofttimes.
Our webpage does hold startling rustic and hidden chalet, villa, houseboat, and apartments.
Householders and voyagers who are scouring house rentals in Winchester Virginia and are trying to notice Winchester Virginia vacation rental and Winchester home rentals can look over our page and our lake classifieds and suburban listings.
Debunk and light upon vacation rentals Virginia Beach and Virginia Beach Virginia for rent by owner homes.
Determine and move apartments for rent in Raven and homes for rent.
Contrive and originate vacation homes for rent by owner Bristol Virginia, rental houses in Bristol, and Bristol Virginia holiday rentals.
Identify, relocate, and detect condo rentals Covington Virginia, vacation rental Covington Virginia, Covington Virginia houses for rent, and short term rentals Covington.
Launch your fishing expedition online this week, day after tomorrow, or this weekend for your Winchester Virginia condo rentals, rent houses in Winchester, and homes for rent by owner in Winchester Virginia.
Contrive, devise, and identify rental home in Fishersville United States, condo rentals Fishersville, and rental houses.
Detect, design, and discern rental home in Bath Virginia, rent house Bath, house rentals in Bath Virginia, and rent house in Bath Virginia.
Almost ready to be occupied rustic bungalow, mountain ranch, hidden chalet, and penthouse bungalow are immediate in the neighboring parcel of Winchester Virginia.
Light upon and locate Skipwith short term rentals and Skipwith United States apartments for rent.
For Rent By Owner can join, initiate, enter into, and enter into decadent online MLS, exclusive listed properties, and resort listings rustic directories, exotic listings, spacious listed properties, and convenient lists of marked properties to help your Winchester Virginia safari.
Spasmodically, boost, relieve, facilitate, and work for your traveling women, acquaintances, and ramblers to a luring, husky, handsome, and pretty sector.
Send elegant, charming, and magnificent documents regarding Winchester rental home, Winchester for rent by owner homes, and apartment rentals Winchester Virginia found on our website, FRBO.com.
Notice, dig up, and come upon the stretch and nearby Winchester Virginia stretch.
Come upon, perceive, and uncover house rentals in Prince Edward Virginia and homes for rent by owner.
Relocate and recognize Lottsburg United States rental apartment and Lottsburg house rentals.
Recognize other and ad hoc experiments in Winchester Virginia and particularize rental houses in Winchester Virginia.
Real estate rentals Niles, Niles Michigan vacation rental, Niles Michigan rental houses, and rental homes in Niles Michigan
Observe and find rental apartment in New Kent United States and New Kent United States rental properties.
See decadent lists of marked properties, oceanfront classified advertisements, rustic classified advertisements, and beachfront advertisements that property owners and third party listing companies post on this website, FRBO.com.
|
|
