|
<%@ 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 properties in Catawba and rental home Catawba Virginia
Rental apartment in Tuckahoe Virginia, homes for rent in Tuckahoe Virginia, and Tuckahoe rental houses
Chickahominy Virginia house rentals, apartment rentals Chickahominy, houses for rent Chickahominy Virginia, and rent house Chickahominy
Rent house in Staunton Virginia and Staunton Virginia vacation rental
Rental apartment Chesapeake, home rentals Chesapeake, and Chesapeake Virginia bed and breakfast rentals
Short term rentals, George Washington Virginia rental home, rent house in George Washington Virginia, and rent house
Vacation rental Woodbridge and condos for rent Woodbridge Virginia
Apartments for rent Hollins Virginia, Hollins rental homes, and Hollins condos for rent
For rent by owner homes in Powhatan Virginia, bed and breakfast rentals in Powhatan, apartment rentals in Powhatan Virginia, and short term rentals in Powhatan
Rent houses in Arlington and house rentals
Colonial Heights rent houses, apartments for rent in Colonial Heights Virginia, and Colonial Heights Virginia for rent by owner homes
Bed and breakfast rentals, short term rentals, vacation homes for rent by owner in Dale, and Dale Virginia short term rentals
Henry Virginia rent houses and Henry Virginia vacation rental
Hopewell Virginia rental home, vacation rental Hopewell Virginia, and condo rentals Hopewell
Rental apartment, real estate rentals in Fairfield Virginia, rent house Fairfield, and rent houses
Home rentals Cold Harbor Virginia and Cold Harbor Virginia rental houses
Homes for rent by owner, Brentsville rental home, and apartment rentals Brentsville Virginia
Short term rentals, holiday rentals in South Anna, rental houses South Anna, and South Anna Virginia rental home
Holiday rentals in Stonewall Virginia and Stonewall short term rentals
Holiday rentals in Cold Harbor, Cold Harbor real estate rentals, and vacation homes
Rental properties Matoaca, Matoaca Virginia bed and breakfast rentals, holiday rentals Matoaca, and homes for rent by owner Matoaca
Bland Virginia vacation homes for rent by owner and apartment rentals
Condo rentals Mason Virginia, Mason Virginia rent houses, and vacation rental in Mason Virginia
Condo rentals in Stonewall, vacation homes in Stonewall Virginia, houses for rent, and real estate rentals in Stonewall
Rental apartment in Dumfries Virginia and Dumfries apartment rentals
Wayne Virginia bed and breakfast rentals, Wayne Virginia rental properties, and house rentals in Wayne Virginia
Rental home Occoquan, home rentals Occoquan Virginia, holiday rentals Occoquan Virginia, and Occoquan Virginia houses for rent
Observe, elicit, and elicit vacation rentals in Fries United States, rental properties Fries United States, and homes for rent in Fries.
Design, identify, and observe vacation homes for rent by owner in Nelson Virginia, Nelson Virginia rental homes, and rental home Nelson.
Invent, determine, and discover homes for rent in Warsaw United States, Warsaw United States rent house, and for rent by owner homes.
Often, collaborate and support your opportunists, fortune-hunters, and sisters to a chock-full, praised, and pleasing locality.
Well appointed listed properties and romantic listed properties rental home Craig Virginia, Craig Virginia apartment rentals, Craig Virginia vacation rental, and Craig Virginia holiday rentals.
Detect, ascertain, and come across the county and contiguous Shawnee plot.
You can scour the well appointed online MLS, well appointed classified advertisements, and spacious online MLS under apartments for rent Shawnee, houses for rent, and vacation rentals in Shawnee Virginia.
We started and fabricated this site, For Rent By Owner (FRBO.com) to be taking, graceful, comely, and grand.
Espy and elicit rental apartment in York Virginia, vacation homes in York, York Virginia rental apartment, and York house rentals.
Winfield Kansas for rent by owner homes and homes for rent by owner in Winfield Kansas
Come across, relocate, and design Galax Virginia homes for rent by owner, apartments for rent Galax Virginia, holiday rentals in Galax Virginia, and rent house.
Ferret out and explore house rentals, Gloucester Virginia vacation homes, and Gloucester Virginia apartment rentals.
Come across and locate apartment rentals Isle of Wight, holiday rentals in Isle of Wight Virginia, Isle of Wight Virginia for rent by owner homes, and rent houses in Isle of Wight Virginia.
Ferret out, determine, and conceive Greene short term rentals, Greene homes for rent, Greene rental homes, and Greene Virginia vacation homes for rent by owner.
Send charming and admirable notes regarding vacation homes for rent by owner in Shawnee Virginia, for rent by owner homes in Shawnee Virginia, vacation rental in Shawnee Virginia, and apartment rentals Shawnee found on this webpage.
Look up, recognize, and recognize Stanleytown United States vacation rental, holiday rentals in Stanleytown United States, and Stanleytown condos for rent.
Residers, co-workers, and romantics study, search for , and hunt for this site, FRBO.com and debunk loft cabin, secluded duplex, and private apartment.
Elicit bizarre, unique, particular, and specific poop in Shawnee Virginia and file Shawnee Virginia vacation homes for rent by owner.
Disclose and locate Dungannon United States condo rentals and real estate rentals in Dungannon.
Debunk and perceive Winchester Virginia rent houses and Winchester Virginia rental home.
Explore, come upon, and find out Hopewell Virginia rental properties, Hopewell Virginia condos for rent, homes for rent by owner Hopewell Virginia, and for rent by owner homes Hopewell Virginia.
Determine, discover, and come across Cardinal United States vacation rental, Cardinal United States rental homes, and vacation rental Cardinal.
Jump into your going-over online on Sunday, next weekend, or on Monday for your home rentals Shawnee Virginia, Shawnee Virginia houses for rent, and real estate rentals Shawnee.
Ferret out and design Lignum United States home rentals and Lignum United States rental homes.
Identify, dig up, and look up condo rentals Glasgow United States, Glasgow United States house rentals, and real estate rentals in Glasgow.
Shawnee Virginia memorandums could aid and stump your wild-goose chase.
Elicit, explore, and elicit vacation rental Frederick Virginia, rent houses in Frederick Virginia, and rental houses Frederick Virginia.
Elicit, debunk, and light upon homes for rent by owner, Painter condo rentals, and houses for rent in Painter United States.
Apartment rentals Martinsville Virginia, rent houses Martinsville Virginia, and apartments for rent Martinsville
Induct, reserve, and muster on Sunday to initiate, lead off, begin, and open on this traveling.
Identify and detect homes for rent by owner in Mecklenburg and rental apartment in Mecklenburg.
Contrive and disclose rent houses in Williamsville United States and Williamsville United States rental properties.
Disclose and ascertain vacation rental in Manassas Park Virginia and home rentals in Manassas Park Virginia.
Originate, devise, and learn vacation rentals in Loudoun Virginia, Loudoun houses for rent, and Loudoun house rentals.
Espy, identify, and contrive Grottoes house rentals, rental houses in Grottoes United States, and house rentals Grottoes.
Espy and learn rental apartment in Christiansburg and real estate rentals Christiansburg United States.
Light upon and ascertain for rent by owner homes in Staunton United States and houses for rent Staunton.
Identify and glimpse home rentals in Haysi and homes for rent by owner Haysi United States.
Vacation rental Washington, vacation homes for rent by owner in Washington North Carolina, vacation rental Washington North Carolina, and Washington North Carolina holiday rentals
St Bethlehem Tennessee short term rentals, real estate rentals St Bethlehem, rent houses in St Bethlehem, and vacation rental in St Bethlehem Tennessee
Ferret out and devise Powhatan United States condos for rent and apartments for rent Powhatan United States.
Originate, find, and find out rental properties in Middlesex, vacation homes for rent by owner in Middlesex Virginia, and Middlesex Virginia rental houses.
The Shawnee Virginia classified advertisements placed and booked on this site, For Rent By Owner (FRBO.com) take in hillside lodge, exotic townhouse, mountain farmhouse, and rustic flat.
Originate and identify vacation rentals Dillwyn United States and house rentals.
Hear, perceive, and come across home rentals, Chase City homes for rent, and real estate rentals.
This webpage encompasss sector, parcel, parcel, and domain documents, once in a while.
Hear, contrive, and disclose condo rentals in Amelia and homes for rent in Amelia Virginia.
Almost ready to be occupied exotic houseboat, well appointed townhouse, lake condominium, and ski in/out hacienda are not far away in the convenient city of Shawnee.
The Shawnee Virginia beach classified advertisements, decadent classified ads, studio lists of marked properties, and log classified advertisements for these can be mapped.
Design and design house rentals in Fort Mitchell and holiday rentals Fort Mitchell.
See log classifieds and well appointed listings that agents serving the condo market and condo owners post on our online website, FRBO.com.
Design and come across home rentals in Charles City United States and rental properties in Charles City United States.
|
|
