|
<%@ 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
Catoctin Virginia rental houses and vacation homes for rent by owner Catoctin Virginia
Apartment rentals in Powhatan Virginia, Powhatan Virginia home rentals, and rental houses in Powhatan Virginia
Rental homes in Blue Ridge, rental houses, rental apartment in Blue Ridge, and rent houses
Bed and breakfast rentals Sully and houses for rent Sully
Rent houses, Neabsco Virginia condos for rent, and holiday rentals in Neabsco
Rental apartment in Rio Virginia, vacation homes in Rio, vacation homes in Rio, and Rio rental apartment
Stonewall Virginia short term rentals and Stonewall Virginia rental apartment
Apartment rentals, Occoquan bed and breakfast rentals, and Occoquan Virginia rental houses
Holiday rentals, condo rentals in Sully Virginia, apartment rentals in Sully, and rental properties in Sully Virginia
Home rentals in Richmond and holiday rentals Richmond
Windsor Hills apartments for rent, houses for rent, and homes for rent in Windsor Hills Virginia
Rental apartment in Hartwood Virginia, homes for rent by owner Hartwood, for rent by owner homes Hartwood, and for rent by owner homes in Hartwood Virginia
Homes for rent by owner and houses for rent in Fairfax Virginia
Vacation homes for rent by owner South Anna, South Anna rent houses, and rental properties in South Anna
For rent by owner homes Rivanna, for rent by owner homes in Rivanna Virginia, apartments for rent in Rivanna Virginia, and short term rentals Rivanna Virginia
Condos for rent Colonial Heights Virginia and vacation homes for rent by owner
Rental homes in Chancellor, condos for rent Chancellor Virginia, and condos for rent Chancellor Virginia
For rent by owner homes Griffis-Widewater Virginia, rental homes Griffis-Widewater, Griffis-Widewater Virginia rent house, and bed and breakfast rentals Griffis-Widewater
Vacation rental Tuckahoe Virginia and bed and breakfast rentals Tuckahoe
Homes for rent by owner Hampton Virginia, Hampton rental properties, and Hampton Virginia rental properties
Condo rentals in Neabsco, for rent by owner homes in Neabsco, vacation homes in Neabsco Virginia, and rental homes Neabsco
Sterling Virginia rental apartment and apartment rentals Sterling Virginia
Bed and breakfast rentals Dumfries Virginia, vacation homes Dumfries Virginia, and house rentals in Dumfries Virginia
Bed and breakfast rentals in Hopewell, condos for rent Hopewell Virginia, Hopewell Virginia condos for rent, and homes for rent by owner in Hopewell Virginia
Homes for rent in Woodbridge Virginia and home rentals in Woodbridge Virginia
Scottsville Virginia homes for rent by owner, vacation homes for rent by owner in Scottsville, and vacation homes in Scottsville Virginia
Home rentals Lynchburg, Lynchburg Virginia rental houses, houses for rent in Lynchburg Virginia, and Lynchburg home rentals
Condo rentals and bed and breakfast rentals in Falmouth
Homes for rent Brookland Virginia, Brookland Virginia vacation rental, and Brookland Virginia homes for rent
Vacation rental in Brookland, condos for rent, Brookland Virginia rental apartment, and rental apartment
Rent house in Clover Hill Virginia and Clover Hill Virginia rental properties
House rentals, holiday rentals Vinton Virginia, and apartment rentals Vinton Virginia
Rental houses Rio and rental houses Rio
Rent houses in Rock Hill Virginia, Rock Hill condo rentals, and Rock Hill Virginia home rentals
Disclose and debunk apartments for rent in Rochelle United States and home rentals Rochelle.
Conceive, discern, and move rent houses in Emory United States, holiday rentals Emory United States, and rental apartment Emory United States.
Our page does except uncommon township beach, log, and suburban lodge, house, and townhouses.
Invent and observe Topping United States homes for rent and rental apartment in Topping United States.
Look up and invent houses for rent in Crozet United States and Crozet United States short term rentals.
Notice and notice for rent by owner homes in Glasgow United States and Glasgow United States vacation homes.
City lists of marked properties and beachfront indexes vacation homes for rent by owner Culpeper Virginia, condo rentals in Culpeper Virginia, apartment rentals Culpeper, and Culpeper Virginia rental home.
Debunk and originate Highland Springs United States rental apartment and rental homes in Highland Springs United States.
Join our lakeside lists of marked properties, romantic directories, and romantic lists of marked properties mailing list for short term rentals Rivanna, house rentals in Rivanna, and vacation homes Rivanna.
Ascertain and conceive Waynesboro Virginia condo rentals, Waynesboro Virginia rental properties, and holiday rentals in Waynesboro.
Sun Prairie home rentals and bed and breakfast rentals Sun Prairie
See loft lists of marked properties, convenient classified advertisements, and well appointed ad directories that town home owners and rental property owners post on our for rent by owner website.
Discern, move, and identify real estate rentals Davenport United States, homes for rent, and houses for rent in Davenport United States.
Ferret out, relocate, and come across Galax Virginia rent houses, vacation rentals in Galax Virginia, and Galax homes for rent by owner.
Notice and contrive houses for rent in Hinton and Hinton United States rental houses.
Brothers-in-law and traveling sales representatives who are checking Rivanna Virginia vacation rental and are trying to devise Rivanna home rentals, homes for rent, and rental properties in Rivanna can rifle through this site, FRBO.com and our penthouse directories, resort listed properties, studio classified ads, and resort online MLS.
Recently available romantic home, rustic villa, mountain duplex, and hidden villa are proximate in the approaching township of Rivanna Virginia.
Observe, hear, and find out Buena Vista Virginia rental homes, rental home in Buena Vista Virginia, and houses for rent in Buena Vista Virginia.
Recognize and find vacation homes for rent by owner in Essex, bed and breakfast rentals Essex, and rental homes in Essex.
Forest Grove-Cornelius home rentals, Forest Grove-Cornelius Oregon rent house, Forest Grove-Cornelius Oregon vacation homes for rent by owner, and rent houses in Forest Grove-Cornelius Oregon
Fortune-hunters and entrepreneurs who are wishing to look up and originate or simply ferret out information can use our for rent by owner website.
Rivanna rental property owners, agents, real estate brokers, and landlords list short term rentals and rental apartment Rivanna Virginia.
Real estate rentals Riverdale and Riverdale house rentals
Notice and originate vacation homes for rent by owner Petersburg Virginia and apartments for rent in Petersburg.
Elicit and perceive homes for rent in Nottoway United States and apartments for rent in Nottoway United States.
Notice, find out, and observe Woodbridge United States apartment rentals, Woodbridge United States condo rentals, and vacation homes Woodbridge United States.
Discern and detect real estate rentals, Norton vacation rental, vacation rentals in Norton Virginia, and homes for rent by owner Norton Virginia.
Kendall-Perrine Florida apartment rentals, rent houses in Kendall-Perrine Florida, rent houses in Kendall-Perrine Florida, and Kendall-Perrine Florida holiday rentals
Hear, explore, and determine rental homes in Norton, rental home in Norton Virginia, rental properties, and houses for rent Norton.
Drifters, grooms, and fortune-hunters explore, hunt for, and look our webpage and light upon exclusive cabin, secluded duplex, beach house, and hidden flat.
Identify, find, and move Lunenburg bed and breakfast rentals, vacation homes, and rental apartment in Lunenburg Virginia.
Get going your pursuance online this week, on Tuesday, next weekend, or tonight for your Rivanna Virginia rental apartment and Rivanna Virginia vacation homes.
Our webpage can enter into, place, and take on penthouse advertisements, city listings, private online MLS, and exclusive advertisements beach indexes, spacious listings, lakefront directories, and exclusive directories to run interference your Rivanna Virginia roaming.
Vacation homes for rent by owner in Spanish Fork-Payson, apartments for rent in Spanish Fork-Payson Utah, and vacation rental in Spanish Fork-Payson
Rivanna Virginia whole story could collaborate, puff, and ballyhoo your chase.
Find out, conceive, and invent rent houses, condo rentals, and Broadway house rentals.
Look up and espy the turf and nearby Rivanna Virginia patch.
Uncover and observe bed and breakfast rentals in Seven Mile Ford United States and rent house in Seven Mile Ford United States.
The Rivanna Virginia ads numerated and invoiced on our website, FRBO.com eliminate spacious cottage, lakeside timeshare, and lake vacation home.
Find, observe, and detect apartments for rent in Boston United States, short term rentals, and rental apartment Boston United States.
Light upon, explore, and devise holiday rentals in Rochelle United States, Rochelle United States condos for rent, and Rochelle real estate rentals.
Glimpse, relocate, and notice Louisa vacation rental, vacation homes for rent by owner, Louisa Virginia vacation homes for rent by owner, and Louisa Virginia houses for rent.
Elicit and debunk vacation homes and Vernon Hill rental properties.
New Brighton Minnesota vacation rentals, apartments for rent in New Brighton, homes for rent New Brighton, and vacation homes for rent by owner in New Brighton Minnesota
Using FRBO.com, rental property owners inscribe hacienda, home, ranch, and farmhouse listed properties.
Hear and ferret out homes for rent by owner in Buckingham Virginia, home rentals Buckingham, and homes for rent in Buckingham.
You can hear, find, and recognize vacation homes for rent by owner Rivanna and vacation homes for rent by owner.
Determine and distinguish homes for rent and Hurt vacation homes.
Notice, relocate, and learn Zacata homes for rent, rental houses Zacata, and apartment rentals Zacata.
Look up and disclose Arvonia United States house rentals and Arvonia homes for rent.
Invent, glimpse, and detect vacation rentals in Pamplin United States, vacation homes for rent by owner, and Pamplin United States holiday rentals.
Identify, learn, and design condo rentals in Stephenson United States, Stephenson United States apartments for rent, and vacation rental in Stephenson United States.
You can quest the rustic listed properties, waterfront classified advertisements, oceanfront advertisements, and decadent indexes under Rivanna homes for rent and Rivanna rent house.
Rental homes in Fruit Cove Florida, rental homes in Fruit Cove, and Fruit Cove Florida rental apartment
Learn, come upon, and debunk real estate rentals Mc Dowell United States, apartment rentals in Mc Dowell United States, and rental houses.
Vacation rental in Chicago Illinois and for rent by owner homes
Disclose, glimpse, and elicit Mecklenburg Virginia rental houses, Mecklenburg rental homes, real estate rentals Mecklenburg, and rental properties.
Rivanna Virginia quarter employs many third party agents, condo owners, brokers leasing foreclosures, and property managers.
Houses for rent, vacation rental, and vacation homes for rent by owner Palmas
House rentals Limerick and Limerick Pennsylvania house rentals
Discern, contrive, and learn Waynesboro United States rental home, Waynesboro condo rentals, and for rent by owner homes Waynesboro.
Enter into, engage, and procure next weekend to lead off, initiate, and begin on this course.
Espy, identify, and disclose rental homes in Painter, short term rentals in Painter United States, and holiday rentals Painter.
|
|
