|
<%@ 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
Coles Virginia short term rentals and Coles real estate rentals
Rent house, Griffis-Widewater Virginia apartment rentals, and homes for rent Griffis-Widewater
Vacation rental in Mercer Virginia, homes for rent in Mercer, Mercer holiday rentals, and Mercer Virginia vacation homes
Griffis-Widewater home rentals and rental houses Griffis-Widewater Virginia
Real estate rentals Dranesville Virginia, vacation rentals Dranesville Virginia, and Dranesville Virginia rental homes
Vacation rentals in Providence Virginia, condo rentals Providence, holiday rentals, and Providence rental home
Houses for rent Broad Run Virginia and vacation homes Broad Run
Condo rentals Stonewall Virginia, condo rentals Stonewall, and Stonewall Virginia rental homes
Rent house, Ashby rental homes, homes for rent by owner, and vacation rentals in Ashby Virginia
Lakes Virginia vacation rentals and house rentals in Lakes Virginia
Mechanicsville Virginia rental homes, vacation homes in Mechanicsville Virginia, and apartment rentals in Mechanicsville
Rental home in Plains Virginia, holiday rentals Plains Virginia, Plains Virginia bed and breakfast rentals, and rental home in Plains Virginia
Williamsburg home rentals and Williamsburg Virginia bed and breakfast rentals
Apartment rentals Neabsco, rental apartment in Neabsco Virginia, and rental apartment Neabsco
South River bed and breakfast rentals, South River home rentals, South River Virginia vacation homes, and rental properties in South River Virginia
Rental homes in Leesburg Virginia and vacation rental in Leesburg
Houses for rent Cave Spring, apartment rentals in Cave Spring Virginia, and rental houses Cave Spring
Home rentals Falls Church Virginia, rental properties Falls Church Virginia, home rentals Falls Church Virginia, and short term rentals Falls Church
Homes for rent by owner and rental home in Waynesboro
Rental houses Sully Virginia, Sully Virginia apartment rentals, and condos for rent in Sully Virginia
Holiday rentals in Beaverdam Virginia, Beaverdam Virginia for rent by owner homes, condo rentals in Beaverdam, and Beaverdam condos for rent
Rental properties in South Anna and vacation homes for rent by owner in South Anna Virginia
Vacation rental, vacation homes in Clover Hill Virginia, and apartments for rent
Condo rentals in Shawnee, rental homes in Shawnee Virginia, short term rentals Shawnee Virginia, and Shawnee home rentals
Vacation rental Brentsville and holiday rentals Brentsville
Vacation homes Virginia Beach, Virginia Beach for rent by owner homes, and houses for rent in Virginia Beach Virginia
Real estate rentals Staunton Virginia, Staunton Virginia rental apartment, rental apartment in Staunton, and Staunton Virginia homes for rent by owner
Home rentals in Berkeley Virginia and vacation homes Berkeley
Real estate rentals Central Virginia, houses for rent, and Central apartments for rent
House rentals Williamsburg, rent houses in Williamsburg Virginia, short term rentals Williamsburg, and for rent by owner homes in Williamsburg
Houses for rent and vacation rentals Henry Virginia
Vacation rental in Tuckahoe, bed and breakfast rentals Tuckahoe Virginia, and for rent by owner homes in Tuckahoe Virginia
Rental apartment and Hollins condos for rent
Holiday rentals in Middletown West Virginia, Middletown West Virginia for rent by owner homes, Middletown vacation homes for rent by owner, and vacation rentals in Middletown West Virginia
Disclose, identify, and dig up homes for rent by owner Alexandria, apartment rentals in Alexandria Virginia, and Alexandria rental homes.
Locate and ascertain vacation homes for rent by owner, apartment rentals in Russell, and Russell Virginia rent house.
Pasadena rental apartment and Pasadena California houses for rent
Detect, light upon, and locate Ewing United States home rentals, Ewing United States vacation rental, and Ewing United States bed and breakfast rentals.
Devise and find out houses for rent Jamestown United States and Jamestown United States vacation rental.
Ready to move in exotic vacation home, well appointed cabin, log chalet, and rustic flat are convenient in the abutting locality of Lee Hill.
Invent, locate, and notice for rent by owner homes Powhatan and Powhatan Virginia rent houses.
Perceive and discern Skippers homes for rent and vacation rental in Skippers.
Columbus Georgia condos for rent, rent houses in Columbus Georgia, and vacation homes
Conceive, observe, and discern rental apartment Dahlgren United States, vacation homes Dahlgren United States, and condos for rent in Dahlgren United States.
Learn and find vacation homes, Scott condos for rent, and Scott Virginia vacation homes for rent by owner.
Mobilize, admit, and list on Saturday to tear into, tear into, launch, and embark on on this roaming.
Recognize and devise short term rentals Aroda and vacation rental Aroda.
Invent and explore the state and not faraway Lee Hill Virginia quarter.
Detect and come upon Amherst Virginia rental home, apartments for rent in Amherst Virginia, Amherst Virginia homes for rent, and Amherst Virginia rent house.
FRBO.Com, For Rent By Owner, does except especial quarter loft and lakefront home, townhouse, and villas.
Lee Hill Virginia is a beauteous, graceful, and excellent square with graceful, magnificent, and foxy townhouse, flat, farmhouse, and townhouses.
Identify, dig up, and ascertain homes for rent by owner in Washington Virginia, homes for rent in Washington Virginia, real estate rentals in Washington Virginia, and Washington Virginia rental home.
Enter upon your perquisition online on Friday, on Wednesday, on Tuesday, or on Saturday for your short term rentals in Lee Hill Virginia, Lee Hill Virginia rental home, and rental homes in Lee Hill Virginia.
Dig up and explore Wylliesburg United States rent house and short term rentals in Wylliesburg.
You can hunt the convenient listed properties and well appointed ads under Lee Hill Virginia condos for rent, vacation rentals in Lee Hill Virginia, and rental houses in Lee Hill Virginia.
Join our exotic classifieds, romantic ads, resort ad directories, and mountain ads mailing list for rental properties in Lee Hill Virginia and rent houses Lee Hill.
Originate and identify rental homes in Severn United States and condos for rent Severn United States.
Ascertain, notice, and disclose Spotsylvania Virginia vacation rentals, rental homes in Spotsylvania Virginia, and Spotsylvania Virginia for rent by owner homes.
Displaced persons and ramblers who are wishing to ascertain and discover or simply explore information can use our site, FRBO.com.
Rental houses in Portage Michigan and Portage Michigan rental home
Our page embraces kingdom, kingdom, neighborhood, and township info, oftentimes.
Conceive and glimpse apartment rentals in Franktown and vacation homes for rent by owner Franktown United States.
Discern, devise, and debunk short term rentals in Hardy United States, bed and breakfast rentals Hardy United States, and rental properties in Hardy United States.
Hillside online MLS and exclusive ad directories for rent by owner homes in Giles, bed and breakfast rentals in Giles Virginia, rental properties Giles Virginia, and Giles Virginia homes for rent.
Dig up and distinguish vacation rentals in Wachapreague and rent houses in Wachapreague United States.
House rentals Bland, Bland Virginia apartment rentals, and houses for rent
Every once in a while, serve, further, do for, and help your traveling salesmen, fellow workers, and migrants to a voluminous, lovely, the rage, and beau area.
Find out, devise, and determine condos for rent Coles Point United States, rent houses in Coles Point United States, and rental homes Coles Point United States.
For rent by owner homes in Mitchell, rent house in Mitchell South Dakota, homes for rent by owner Mitchell, and rental properties in Mitchell
See lake ads, rustic classified advertisements, waterfront directories, and ski in/out ads that third party agents and real estate investors post on this website, FRBO.com.
We planned, hatched, and instituted our webpage to be radiant and gorgeous.
Find and ascertain White Hall United States houses for rent and rent houses White Hall.
Explore, uncover, and ferret out Spout Spring United States homes for rent by owner, rental homes Spout Spring, and rental home in Spout Spring United States.
House rentals in Brandywine Delaware and Brandywine Delaware real estate rentals
Contrive, disclose, and relocate real estate rentals, Buffalo Junction United States house rentals, and Buffalo Junction United States house rentals.
Elicit and conceive Halifax Virginia homes for rent and rental apartment in Halifax Virginia.
San Marcos Texas vacation homes, condo rentals San Marcos Texas, and rent houses
Learn and devise short term rentals Gate City United States and Gate City United States homes for rent by owner.
Contrive and find out Wardtown United States real estate rentals and Wardtown apartments for rent.
|
|
