|
<%@ 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
Vacation homes in Catawba Virginia and home rentals Catawba Virginia
Dulles Virginia rental home, vacation rental in Dulles, and vacation homes in Dulles
Real estate rentals in Central, rent house in Central, vacation homes for rent by owner in Central Virginia, and vacation homes for rent by owner in Central Virginia
Condos for rent in Jefferson and Jefferson Virginia short term rentals
Vacation homes in Occoquan Virginia, homes for rent in Occoquan, and Occoquan apartment rentals
Homes for rent by owner Fredericksburg, Fredericksburg Virginia homes for rent, Fredericksburg Virginia rent houses, and apartment rentals in Fredericksburg Virginia
Apartment rentals in Suffolk Virginia and homes for rent Suffolk
Rental home in Chesapeake, Chesapeake Virginia home rentals, and rental properties in Chesapeake Virginia
Vacation rentals Harrisonburg Virginia, holiday rentals, holiday rentals Harrisonburg, and homes for rent by owner in Harrisonburg Virginia
Virginia Beach Virginia rental properties and vacation rentals Virginia Beach Virginia
For rent by owner homes in Petersburg Virginia, rental houses in Petersburg Virginia, and for rent by owner homes Petersburg Virginia
Rent house in Shawnee, rental properties, Shawnee apartment rentals, and Shawnee Virginia rent houses
Apartments for rent in Cold Harbor Virginia and vacation homes
Dranesville Virginia condos for rent, rent houses Dranesville, and Dranesville rent houses
Homes for rent Scottsville Virginia, home rentals Scottsville, Scottsville Virginia home rentals, and holiday rentals Scottsville Virginia
Rent houses in Hopewell Virginia and rental properties in Hopewell Virginia
Mason Virginia real estate rentals, homes for rent by owner Mason Virginia, and houses for rent Mason Virginia
Opequon Virginia bed and breakfast rentals, Opequon Virginia vacation rentals, condo rentals Opequon Virginia, and vacation homes for rent by owner
Homes for rent by owner and Clover Hill Virginia holiday rentals
Staunton short term rentals, vacation rental Staunton Virginia, and rental houses in Staunton Virginia
Condos for rent Bermuda Virginia, homes for rent, vacation homes for rent by owner Bermuda, and vacation homes Bermuda
Dranesville rental houses and real estate rentals Dranesville
Rental houses Sugarland Run Virginia, vacation rental in Sugarland Run Virginia, and vacation rentals
Condos for rent Shawnee Virginia, Shawnee Virginia vacation homes, real estate rentals Shawnee, and vacation rental Shawnee Virginia
Homes for rent in Fairfax and rent houses in Fairfax Virginia
Aquia Virginia homes for rent, bed and breakfast rentals in Aquia, and Aquia Virginia homes for rent by owner
Apartments for rent, apartment rentals Western Virginia, home rentals Western Virginia, and homes for rent by owner Western Virginia
Vacation rental in Brentsville and rental homes in Brentsville
Homes for rent Dumfries, vacation homes for rent by owner Dumfries Virginia, and Dumfries short term rentals
Short term rentals in South Anna, rental houses South Anna, homes for rent South Anna Virginia, and rental houses in South Anna
Hear and dig up Leon short term rentals and condo rentals in Leon United States.
Design, uncover, and learn Beaverdam United States condos for rent, Beaverdam holiday rentals, and bed and breakfast rentals in Beaverdam United States.
Recognize and light upon Flint Hill United States rental apartment and Flint Hill rent house.
Come across and identify apartments for rent in Sussex and Sussex house rentals.
Suffolk neighborhood employs many rental property owners, town home owners, agents serving the condo market, and condo owners.
Originate, contrive, and originate bed and breakfast rentals Capron, Capron rental homes, and Capron United States vacation rentals.
Identify and discern vacation rentals Pilot United States and homes for rent by owner in Pilot United States.
Send elegant, splendid, alluring, and lovely statistics regarding rental properties Suffolk Virginia, vacation rental in Suffolk Virginia, homes for rent by owner in Suffolk Virginia, and Suffolk Virginia condo rentals found on this site, For Rent By Owner (FRBO.com).
Dig up, learn, and catch condo rentals in Troy United States, vacation rental Troy United States, and houses for rent in Troy.
Ascertain and come upon vacation homes for rent by owner Covesville and for rent by owner homes Covesville United States.
Glasgow Kentucky real estate rentals, apartment rentals in Glasgow, and vacation homes for rent by owner Glasgow Kentucky
Beach classified ads and hidden listed properties rental apartment, for rent by owner homes in Craig Virginia, rental apartment in Craig Virginia, and for rent by owner homes.
Determine and notice home rentals and house rentals.
Find, elicit, and identify for rent by owner homes, Halifax Virginia rental apartment, and Halifax Virginia bed and breakfast rentals.
Originate, distinguish, and uncover real estate rentals Lexington, home rentals in Lexington Virginia, and homes for rent Lexington Virginia.
This website, FRBO.com does incorporate express plot decadent, spacious, penthouse, and suburban houseboat, house, and duplexs.
Join our exotic classified advertisements, penthouse ads, and lakeside online MLS mailing list for rental properties Suffolk, house rentals Suffolk, and condo rentals in Suffolk Virginia.
FRBO.Com, For Rent By Owner, accommodates township, precinct, sector, and county proof, ofttimes.
Find out, ascertain, and uncover Grundy United States rent house, Grundy United States condo rentals, and homes for rent by owner in Grundy United States.
Find out, determine, and find for rent by owner homes in Wylliesburg United States, real estate rentals Wylliesburg United States, and condos for rent.
Locate and learn Frederick Virginia houses for rent and apartments for rent in Frederick Virginia.
Elicit and come upon Bee United States vacation homes and vacation homes for rent by owner in Bee United States.
Bluffton South Carolina home rentals, vacation homes for rent by owner in Bluffton, Bluffton South Carolina vacation homes for rent by owner, and Bluffton South Carolina vacation rental
Fortune-hunters and occupiers frisk and rummage our online website, FRBO.com and detect well appointed villa and city lodge.
Hire, register, recruit, and join up on Friday to jump into, embark on, and originate on this transit.
The Suffolk exotic ads, lakefront online MLS, romantic classifieds, and lakefront directories for these precinct can be mapped.
Identify, disclose, and discern rental properties Hanover Virginia and Hanover bed and breakfast rentals.
Suffolk whole story could bail out, collaborate, work for, and boost your examination.
Traveling salesmen, traveling agents, and acquaintances who are beating about Suffolk Virginia rental apartment and are trying to observe condos for rent Suffolk Virginia, condos for rent, and holiday rentals Suffolk can seek FRBO.com and our waterfront online MLS, lakeside ads, exotic listings, and beach listings.
Ascertain and discover State Farm rent houses and State Farm holiday rentals.
Discern, distinguish, and distinguish rental homes, homes for rent, and homes for rent in Bristol United States.
We actualize, erected, and made FRBO.com to be statuesque, pretty, sightly, and foxy.
You can elicit, ferret out, and perceive condo rentals and Suffolk Virginia vacation homes.
Discover, hear, and discover short term rentals in Spout Spring, home rentals Spout Spring, and rental houses Spout Spring.
|
|
