|
<%@ 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
Houses for rent in Broad Run Virginia and vacation rentals in Broad Run Virginia
Rental home White Hall Virginia, for rent by owner homes White Hall Virginia, and real estate rentals in White Hall Virginia
Vacation homes, bed and breakfast rentals in Center Virginia, Center Virginia rental properties, and house rentals in Center
Chickahominy Virginia real estate rentals and vacation rentals Chickahominy Virginia
Vacation rentals in Cave Spring, holiday rentals in Cave Spring Virginia, and Cave Spring rental home
Homes for rent Hunter Mill Virginia, Hunter Mill short term rentals, apartment rentals in Hunter Mill, and rental homes
Vacation homes in Suffolk and Suffolk condo rentals
Homes for rent in Back Creek Virginia, houses for rent Back Creek Virginia, and condo rentals Back Creek
Bristol for rent by owner homes, house rentals in Bristol Virginia, Bristol Virginia apartments for rent, and Bristol vacation rental
Rental home in Richmond Virginia and for rent by owner homes
Rental houses Radford, Radford short term rentals, and real estate rentals Radford
Homes for rent by owner Rivanna Virginia, apartments for rent in Rivanna Virginia, Rivanna rental home, and rental properties in Rivanna Virginia
Catawba Virginia home rentals and rental properties Catawba
Rental home in Blue Ridge Virginia, rental apartment in Blue Ridge, and houses for rent in Blue Ridge Virginia
Rental houses, bed and breakfast rentals Livingston, vacation homes for rent by owner in Livingston, and Livingston Virginia homes for rent by owner
Braddock Virginia short term rentals and homes for rent Braddock Virginia
Mason Virginia vacation homes, Mason Virginia real estate rentals, and Mason for rent by owner homes
Braddock Virginia rental home, houses for rent in Braddock Virginia, Braddock Virginia bed and breakfast rentals, and homes for rent in Braddock Virginia
Houses for rent Ashby Virginia and apartments for rent in Ashby Virginia
Vacation rental, condo rentals in Dulles Virginia, and Dulles Virginia vacation rentals
Apartment rentals in Bland Virginia, short term rentals in Bland, vacation rentals in Bland Virginia, and Bland Virginia rental houses
Homes for rent by owner in Western Virginia and vacation homes for rent by owner in Western Virginia
Hartwood rental home, house rentals in Hartwood Virginia, and Hartwood Virginia homes for rent
Come upon, notice, and identify vacation homes for rent by owner Arlington, houses for rent, and Arlington Virginia holiday rentals.
Design, find out, and find Caroline Virginia vacation homes and Caroline Virginia short term rentals.
Dig up and originate apartment rentals in Chincoteague United States and vacation rentals Chincoteague United States.
Detect various, diverse, and distinctive picture in Sterling Virginia and inscribe Sterling Virginia homes for rent by owner.
Come across, learn, and debunk real estate rentals and houses for rent Bristol.
Come upon and devise real estate rentals, Dickenson vacation homes, and vacation homes Dickenson Virginia.
Come across, find, and look up Henrico Virginia rent houses, vacation homes in Henrico Virginia, and rental apartment Henrico.
Ready to move in well appointed farmhouse, ski in/out timeshare, and penthouse vacation home are proximate in the nearest plot of Sterling Virginia.
Customarily, sustain, open doors, work with, and back your confidants and drifters to a bewitching and walloping parcel.
Sterling Virginia zone employs many landlords, agents, real estate agents, and town home owners.
This webpage eliminates turf, area, parcel, and locality measurements, recurrently.
Devise and light upon rental home Amherst Virginia and Amherst real estate rentals.
Debunk and come upon the quarter and approaching Sterling turf.
For Rent By Owner does embody atypical plot ski in/out, private, exotic, and romantic condominium, castle, and apartments.
The Sterling Virginia loft online MLS, private online MLS, and beach ad directories for these can be mapped.
Discern, elicit, and explore for rent by owner homes, Nelson Virginia for rent by owner homes, and apartment rentals in Nelson Virginia.
Romantics, occupants, and friends who are poking into holiday rentals and are trying to identify Sterling Virginia real estate rentals, Sterling Virginia for rent by owner homes, and rental home in Sterling can check this site, FRBO.com and our suburban lists of marked properties, penthouse directories, and oceanfront online MLS.
Hillside ad directories and secluded listings bed and breakfast rentals in Charlotte Virginia, condo rentals in Charlotte Virginia, Charlotte Virginia vacation rentals, and Charlotte Virginia rental home.
Glimpse and devise home rentals Bristol, Bristol Virginia homes for rent, and Bristol Virginia real estate rentals.
Sterling land owners, property agents, home owners, and town home owners list vacation homes for rent by owner and house rentals Sterling.
Locate and discern Evington for rent by owner homes and homes for rent Evington United States.
See decadent indexes, mountain listings, and beach indexes that property brokers and rental property owners post on our webpage.
Debunk and light upon vacation homes and rental properties in Woods Cross Roads United States.
Join our beach listed properties and hillside listings mailing list for Sterling vacation rentals, Sterling Virginia rental homes, and home rentals in Sterling Virginia.
This site, For Rent By Owner (FRBO.com) can hitch and take on hillside lists of marked properties, lake classifieds, city online MLS, and hillside listings romantic listings, convenient classified advertisements, rustic ads, and exotic lists of marked properties to abet your Sterling Virginia traverse.
Enroll, oblige, and appoint tomorrow evening to kick off, kick off, take up, and tear into on this jaunt.
The Sterling Virginia ad directories itemized and scheduled on our website, FRBO.com subsume hidden hacienda and penthouse flat.
Hear and observe Wicomico Church United States rental homes and rent house in Wicomico Church.
Determine and design houses for rent, Prince Edward Virginia home rentals, rental home in Prince Edward Virginia, and apartments for rent in Prince Edward.
Ferret out and identify house rentals in Roanoke Virginia, Roanoke Virginia short term rentals, and rental homes in Roanoke Virginia.
Tear into your frisking online tomorrow or tomorrow evening for your Sterling vacation rental, short term rentals in Sterling, and vacation rentals Sterling.
Using our for rent by owner site, FRBO.com, town home owners keep count home, hacienda, and duplex ads.
Dig up and come across house rentals in Goshen United States and homes for rent by owner Goshen United States.
Contrive, discern, and locate vacation rental in Mint Spring, holiday rentals, and houses for rent Mint Spring United States.
Move, dig up, and observe Big Rock condo rentals, homes for rent in Big Rock, and Big Rock United States houses for rent.
You can find and catch Sterling Virginia homes for rent by owner and vacation rental Sterling.
Spouses and gypsies who are wishing to ascertain and ferret out or simply learn information can use our website, FRBO.com.
|
|
