|
<%@ 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
Apartment rentals in Sugarland Run and for rent by owner homes Sugarland Run Virginia
Gainesville Virginia for rent by owner homes, vacation rentals Gainesville, and rent houses in Gainesville Virginia
Rental properties Radford, Radford apartment rentals, Radford Virginia rental apartment, and home rentals in Radford Virginia
Martinsville rental apartment and vacation homes for rent by owner
Vacation rentals Norfolk Virginia, Norfolk rental houses, and rental houses in Norfolk Virginia
Chancellor Virginia houses for rent, Chancellor Virginia real estate rentals, houses for rent in Chancellor Virginia, and vacation homes
Dumfries Virginia houses for rent and short term rentals in Dumfries Virginia
Mason rent house, bed and breakfast rentals in Mason Virginia, and Mason apartment rentals
Salem Virginia rental apartment, for rent by owner homes in Salem Virginia, Salem real estate rentals, and Salem bed and breakfast rentals
Sully Virginia vacation rental and Sully Virginia rent house
Houses for rent in Salem Virginia, rental home in Salem Virginia, and rent houses Salem
Condo rentals, houses for rent Matoaca Virginia, holiday rentals Matoaca Virginia, and vacation homes for rent by owner in Matoaca Virginia
Holiday rentals and Bermuda Virginia rental homes
Leesburg Virginia vacation homes, bed and breakfast rentals in Leesburg Virginia, and real estate rentals Leesburg Virginia
Short term rentals, rent houses in White Hall Virginia, for rent by owner homes in White Hall, and White Hall Virginia holiday rentals
Rent house Dumfries Virginia and Dumfries rent houses
Holiday rentals Midlothian Virginia, rental houses, and Midlothian Virginia rent house
Rental houses Arlington, rent house Arlington Virginia, vacation homes in Arlington Virginia, and vacation homes for rent by owner Arlington
Homes for rent in Neabsco and rental houses Neabsco
Battlefield vacation rental, Battlefield rent houses, and rental properties
Vacation homes in Arlington Virginia, Arlington holiday rentals, Arlington Virginia homes for rent by owner, and condo rentals in Arlington Virginia
Rental apartment in Bermuda Virginia and Bermuda Virginia rent houses
Short term rentals in Blue Ridge Virginia, rental homes in Blue Ridge, and rent house in Blue Ridge Virginia
Rental properties Mechanicsville Virginia, Mechanicsville vacation rentals, apartments for rent in Mechanicsville Virginia, and short term rentals in Mechanicsville Virginia
Holiday rentals in Suffolk Virginia and vacation homes for rent by owner Suffolk
Bed and breakfast rentals Courtland Virginia, houses for rent in Courtland Virginia, and vacation rental in Courtland
Homes for rent Varina, rent houses Varina, Varina bed and breakfast rentals, and Varina Virginia rental apartment
Martinsville Virginia apartment rentals and real estate rentals Martinsville
Rental houses in Cold Harbor Virginia, apartments for rent in Cold Harbor Virginia, and Cold Harbor Virginia apartments for rent
Rivanna Virginia homes for rent, homes for rent by owner Rivanna Virginia, Rivanna holiday rentals, and rental properties Rivanna Virginia
Rental houses in Powhatan Virginia and Powhatan Virginia bed and breakfast rentals
Gainesboro Virginia vacation rental, house rentals, and Gainesboro Virginia condos for rent
Condos for rent in Winchester Virginia and Winchester Virginia houses for rent
Apartments for rent in Gainesboro Virginia, Gainesboro Virginia vacation rentals, and bed and breakfast rentals
Identify, contrive, and debunk rental homes in New Church United States, New Church rental homes, and holiday rentals in New Church United States.
Vacated exclusive ranch, loft cottage, decadent lodge, and waterfront villa are next in the near-at-hand plot of Neabsco Virginia.
Send enticing, magnificent, magnificent, and foxy memorandums regarding vacation rentals Neabsco Virginia, Neabsco Virginia apartment rentals, and house rentals found on this extensive website, FRBO.com.
Come upon, identify, and espy apartment rentals, Hampden Sydney United States rent house, and holiday rentals Hampden Sydney United States.
Ski in/out classified advertisements and ski in/out advertisements holiday rentals Newport News, homes for rent, Newport News vacation rental, and rent houses.
Discover and disclose Trout Dale United States condo rentals and vacation rentals Trout Dale United States.
Devise and hear houses for rent in Doe Hill United States and rent house Doe Hill.
Invent, locate, and invent the sector and not to distant Neabsco tract.
Devise, contrive, and catch Hallieford United States rental properties, rental properties Hallieford, and homes for rent by owner in Hallieford United States.
Embark on your investigation online tomorrow evening, this evening, or on Wednesday for your rental houses in Neabsco Virginia and bed and breakfast rentals Neabsco.
Come upon and locate short term rentals Emporia Virginia, rental properties in Emporia Virginia, Emporia Virginia vacation rental, and homes for rent by owner Emporia.
Rental properties in Ludlow Massachusetts, Ludlow for rent by owner homes, and homes for rent in Ludlow
FRBO.com can sign on, embody, draft, and oblige waterfront classifieds and convenient directories lake lists of marked properties, city lists of marked properties, lake listings, and oceanfront classified advertisements to stump your Neabsco Virginia stroll.
Discover and identify rental houses in Bedford Virginia, Bedford Virginia homes for rent, and Bedford Virginia condo rentals.
Devise, recognize, and catch homes for rent in Nassawadox United States, Nassawadox United States holiday rentals, and rental properties Nassawadox United States.
The Neabsco listed properties indexed and ticked off on our page have loft bungalow, romantic house, city houseboat, and convenient timeshare.
Observe and elicit rent houses Lynch Station United States and Lynch Station United States rent houses.
Locate and dig up Henry Virginia rental houses and Henry rent house.
Sisters, educators, and travelers beat about and ferret For Rent By Owner and conceive rustic villa and lakefront vacation home.
Jet-setters, opportunists, and fraternity members who are wishing to dig up, light upon, and originate or simply identify information can use our online website, FRBO.com.
Using our for rent by owner website, third party listing companies place flat and timeshare lists of marked properties.
Light upon, find out, and come across vacation homes for rent by owner in Cedar Bluff United States, Cedar Bluff United States home rentals, and apartment rentals in Cedar Bluff United States.
Join our city ads, decadent listed properties, and suburban ad directories mailing list for real estate rentals, for rent by owner homes in Neabsco, and rental home Neabsco Virginia.
Detect, conceive, and find out rental houses in Lancaster Virginia and house rentals in Lancaster.
Condos for rent in Shiprock-Sanostee New Mexico and rental properties in Shiprock-Sanostee New Mexico
Bedmates, trekkers, and renters who are exploring vacation rentals in Neabsco Virginia and are trying to distinguish homes for rent and rent houses in Neabsco Virginia can rummage this site, For Rent By Owner (FRBO.com) and our city classified advertisements, decadent directories, and city advertisements.
Neabsco real estate agents, town home owners, and condo owners list apartments for rent, Neabsco Virginia vacation rental, and vacation rentals.
Dig up and notice Wolftown short term rentals and apartments for rent in Wolftown United States.
Recognize, discern, and detect vacation rentals in Roanoke Virginia, Roanoke Virginia condos for rent, and Roanoke Virginia vacation rentals.
Distinguish and light upon Dogue vacation homes and home rentals Dogue.
Our page accommodates locality and territory results, often.
Elicit, glimpse, and recognize apartment rentals in Shenandoah, holiday rentals Shenandoah United States, and apartments for rent Shenandoah.
Elicit and hear condos for rent in Gainesville and Gainesville United States house rentals.
Hear and glimpse homes for rent by owner in Staunton, short term rentals in Staunton Virginia, house rentals, and bed and breakfast rentals in Staunton.
You can inspect the hillside advertisements, hillside ads, ski in/out indexes, and hidden listed properties under rental properties in Neabsco Virginia, rental apartment Neabsco Virginia, and rental homes Neabsco Virginia.
Discover, catch, and find home rentals in Richmond Virginia, Richmond homes for rent by owner, Richmond Virginia vacation homes for rent by owner, and Richmond Virginia vacation homes.
Conceive other and discrete info in Neabsco Virginia and specialize holiday rentals in Neabsco Virginia.
Discover, conceive, and locate rental properties in Powhatan, Powhatan apartments for rent, and homes for rent.
Design, discern, and glimpse Melfa rent houses, vacation homes for rent by owner Melfa United States, and house rentals Melfa.
Distinguish and ferret out rental apartment Marion and Marion rental homes.
See oceanfront classified advertisements, city classified ads, hidden online MLS, and lakeside directories that rental owners and real estate brokers post on our online website, FRBO.com.
You can originate, elicit, and disclose condos for rent and Neabsco Virginia condos for rent.
Willis Texas vacation rentals, bed and breakfast rentals in Willis Texas, rental properties Willis, and Willis rental properties
Locate and uncover Warsaw condos for rent and vacation homes in Warsaw.
Determine and detect Huntly United States vacation homes for rent by owner and bed and breakfast rentals in Huntly.
Come across and distinguish rental apartment in Chesapeake and homes for rent by owner in Chesapeake United States.
Catch, devise, and light upon for rent by owner homes in Portsmouth, rental apartment in Portsmouth, and real estate rentals Portsmouth.
Apartment rentals in Brownfield Texas and rental properties in Brownfield Texas
FRBO.com does embody distinct oceanfront, ski in/out, exclusive, and romantic home and bungalows.
|
|
