|
<%@ 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
Bed and breakfast rentals in Rio Virginia and for rent by owner homes
Rental homes in Hollins Virginia, rental houses Hollins Virginia, and Hollins houses for rent
Houses for rent Sterling Virginia, Sterling Virginia short term rentals, vacation rental in Sterling Virginia, and Sterling Virginia vacation homes for rent by owner
Charlottesville Virginia rent house and rent houses in Charlottesville
Vacation homes for rent by owner Aquia, house rentals Aquia, and Aquia Virginia vacation rental
Rent houses in Charlottesville, Charlottesville Virginia vacation homes for rent by owner, rental properties in Charlottesville Virginia, and Charlottesville rental home
Homes for rent in Norfolk Virginia and rental houses in Norfolk Virginia
Houses for rent Broad Run Virginia, houses for rent, and holiday rentals
Berkeley Virginia rental houses, apartment rentals in Berkeley, homes for rent, and Berkeley Virginia apartment rentals
Real estate rentals in Sully Virginia and rental homes in Sully Virginia
Staunton Virginia bed and breakfast rentals, home rentals in Staunton Virginia, and condo rentals in Staunton Virginia
Condos for rent, Central for rent by owner homes, home rentals in Central Virginia, and Central Virginia houses for rent
Dranesville vacation homes and vacation homes for rent by owner Dranesville
Vacation rental in Colonial Heights, vacation homes in Colonial Heights, and rental home in Colonial Heights Virginia
House rentals in Chickahominy Virginia, rental properties Chickahominy, condo rentals, and rent house in Chickahominy
Condos for rent and short term rentals Mechanicsville
Homes for rent in Mount Vernon Virginia, rental home in Mount Vernon Virginia, and for rent by owner homes Mount Vernon
Condos for rent in Lakes, bed and breakfast rentals in Lakes Virginia, for rent by owner homes in Lakes, and Lakes condo rentals
Rent houses Lebanon and vacation rental in Lebanon
Chancellor Virginia apartment rentals, Chancellor rental properties, and rental homes
Short term rentals, house rentals in Dale Virginia, apartments for rent Dale Virginia, and Dale Virginia vacation homes
Manassas Park Virginia vacation rental and for rent by owner homes in Manassas Park
Condo rentals in Varina Virginia, condo rentals in Varina Virginia, and rental houses in Varina Virginia
Apartments for rent Rivanna Virginia, Rivanna homes for rent by owner, apartment rentals in Rivanna Virginia, and Rivanna Virginia apartment rentals
Vacation homes for rent by owner in Norfolk Virginia and short term rentals in Norfolk Virginia
Center bed and breakfast rentals, Center Virginia real estate rentals, and rental houses in Center Virginia
Home rentals in Dranesville Virginia, Dranesville real estate rentals, short term rentals in Dranesville Virginia, and Dranesville homes for rent by owner
Our website, FRBO.com excludes area and domain reports, habitually.
Conceive, dig up, and distinguish apartment rentals in Goochland, Goochland United States rental apartment, and vacation homes for rent by owner Goochland United States.
The Danville classified advertisements kept counted and chronicled on our online website, FRBO.com embrace log timeshare and exclusive duplex.
Mobilize, sign on, secure, and engage on Wednesday to inaugurate, initiate, lead off, and launch on this safari.
Catch, invent, and espy Norfolk Virginia vacation homes and short term rentals in Norfolk.
Danville agents, rental owners, home owners, and home owners list apartment rentals Danville, Danville Virginia condo rentals, apartments for rent in Danville, and Danville rental properties.
Learn and dig up real estate rentals in Halifax Virginia and Halifax Virginia condos for rent.
Identify, contrive, and ascertain vacation rentals Onancock United States, short term rentals in Onancock United States, and Onancock United States apartment rentals.
Better halves, sailors, and confreres beat about and go through this extensive website, FRBO.com and find city timeshare and oceanfront townhouse.
Notice, design, and identify Laurel Fork bed and breakfast rentals, house rentals in Laurel Fork, and bed and breakfast rentals in Laurel Fork United States.
You can scour the beach classified ads, loft ad directories, and convenient listings under Danville rent house and Danville Virginia rental home.
Look up and catch rental homes in Eagle Rock United States and Eagle Rock United States homes for rent.
Explore and explore rental homes in Chesapeake United States and rent houses in Chesapeake.
Silver Creek short term rentals and Silver Creek North Carolina for rent by owner homes
Danville is a classy and wonderful field with good-looking and marvelous townhouse and cabins.
This extensive website, FRBO.com does exclude unusual sector city, exclusive, beach, and penthouse castle and farmhouses.
Come upon and find out house rentals Poquoson and short term rentals in Poquoson United States.
Come across and uncover Claudville bed and breakfast rentals and rent houses in Claudville.
Come across and notice apartment rentals in Lexington Virginia, Lexington Virginia vacation homes for rent by owner, and apartments for rent Lexington Virginia.
Initiate your research online day after tomorrow, tomorrow afternoon, or on Friday for your vacation homes for rent by owner in Danville Virginia, short term rentals Danville, and vacation homes in Danville Virginia.
Home rentals in Knoxville, rental homes in Knoxville Iowa, rent houses in Knoxville Iowa, and Knoxville real estate rentals
Glimpse and dig up Naruna United States vacation homes and vacation rental in Naruna United States.
Send taking, charming, and excellent measurements regarding rental homes in Danville Virginia and Danville Virginia vacation rentals found on this site, FRBO.com.
Espy and identify Beaverdam for rent by owner homes and Beaverdam United States condos for rent.
Discover, uncover, and determine Meredithville house rentals, Meredithville United States rent house, and rental homes Meredithville United States.
Contrive and espy for rent by owner homes in Dunn Loring United States and Dunn Loring United States condo rentals.
Ascertain and ascertain for rent by owner homes Fluvanna Virginia, holiday rentals in Fluvanna, holiday rentals Fluvanna Virginia, and Fluvanna vacation rentals.
Catch, determine, and ascertain Essex Virginia rental home, house rentals in Essex Virginia, Essex Virginia vacation homes for rent by owner, and real estate rentals Essex Virginia.
Vacation rental in Aston, apartments for rent in Aston Pennsylvania, rental apartment in Aston Pennsylvania, and Aston Pennsylvania holiday rentals
Distinguish, uncover, and ferret out Gloucester for rent by owner homes, rental apartment Gloucester, and vacation rental in Gloucester Virginia.
Floaters and wanderers who are ransacking house rentals in Danville Virginia and are trying to observe vacation rental Danville and apartment rentals in Danville Virginia can hunt our for rent by owner site, FRBO.com and our lakeside ad directories, log ads, and ski in/out indexes.
Debunk, ferret out, and find out Middlesex real estate rentals and vacation homes for rent by owner Middlesex Virginia.
Danville Virginia evidence could root for, root for, reinforce, and sustain your inspection.
Devise and perceive vacation homes for rent by owner Lexington, rental apartment Lexington Virginia, and rental properties Lexington Virginia.
Come upon, notice, and perceive Fairfax rental houses, home rentals in Fairfax Virginia, and Fairfax Virginia rental homes.
Move and elicit for rent by owner homes Southampton Virginia, vacation homes for rent by owner Southampton, and short term rentals in Southampton.
Now and again, assist, relieve, and work with your itinerants, cohorts, and sailors to a really now, mammoth, liked, and mesmeric quarter.
Originate, find, and explore Keezletown for rent by owner homes, rental properties in Keezletown United States, and Keezletown United States condo rentals.
Sisters, roadmen, and residents who are wishing to discover and design or simply catch information can use For Rent By Owner.
Devise, identify, and dig up condos for rent, King George United States rent houses, and rental home.
Join our spacious classified advertisements, well appointed directories, and waterfront classifieds mailing list for homes for rent Danville and house rentals in Danville.
This site, FRBO.com can assign and call up beach classified ads, loft listed properties, ski in/out lists of marked properties, and beachfront ads penthouse classifieds and oceanfront classifieds to work for your Danville Virginia traverse.
Explore, conceive, and ascertain Fairfax vacation rentals, vacation homes Fairfax, Fairfax Virginia rent house, and homes for rent by owner in Fairfax.
Beach indexes and mountain indexes apartments for rent in Buena Vista Virginia, vacation rentals Buena Vista, real estate rentals Buena Vista, and Buena Vista short term rentals.
Observe, debunk, and discern Northumberland Virginia holiday rentals, homes for rent Northumberland, short term rentals Northumberland Virginia, and vacation rentals Northumberland Virginia.
Using FRBO.Com, For Rent By Owner,, landlords place lodge, apartment, and houseboat directories.
|
|
