|
<%@ 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 Sully and holiday rentals in Sully Virginia
Condo rentals in Chancellor Virginia, Chancellor real estate rentals, and vacation homes
Rental houses Livingston Virginia, Livingston Virginia home rentals, Livingston short term rentals, and real estate rentals
Homes for rent in Gainesboro Virginia and house rentals
Salem for rent by owner homes, rental homes in Salem Virginia, and vacation rentals in Salem Virginia
Rent houses, Powhatan Virginia apartments for rent, Powhatan Virginia real estate rentals, and vacation homes for rent by owner in Powhatan
Home rentals in Matoaca Virginia and rental properties
Manassas condos for rent, Manassas Virginia rental houses, and apartment rentals Manassas Virginia
House rentals, Fredericksburg Virginia homes for rent by owner, home rentals in Fredericksburg, and Fredericksburg Virginia house rentals
Aquia Virginia rental houses and apartment rentals in Aquia Virginia
Woodbridge Virginia vacation rentals, houses for rent in Woodbridge, and short term rentals
Houses for rent Lee Hill Virginia, homes for rent by owner in Lee Hill, vacation homes for rent by owner Lee Hill, and apartment rentals in Lee Hill Virginia
Condo rentals and for rent by owner homes in Powhatan
Bristol Virginia vacation rentals, vacation rentals, and Bristol Virginia vacation rental
Berkeley bed and breakfast rentals, vacation rentals Berkeley Virginia, condos for rent, and Berkeley Virginia apartment rentals
Bed and breakfast rentals and holiday rentals
Homes for rent by owner, Dale Virginia short term rentals, and rental apartment in Dale Virginia
Home rentals Back Creek Virginia, Back Creek vacation rentals, Back Creek Virginia houses for rent, and home rentals Back Creek
Holiday rentals Jefferson Virginia and Jefferson houses for rent
Rental home in Chesapeake Virginia, short term rentals Chesapeake Virginia, and Chesapeake Virginia apartments for rent
Vacation rentals in Ashby, Ashby Virginia houses for rent, Ashby Virginia houses for rent, and holiday rentals Ashby
Radford Virginia rent houses and rental apartment Radford
Rental apartment Chancellor, homes for rent in Chancellor Virginia, and bed and breakfast rentals in Chancellor
Holiday rentals in Griffis-Widewater Virginia, rental houses Griffis-Widewater, Griffis-Widewater Virginia bed and breakfast rentals, and for rent by owner homes Griffis-Widewater Virginia
Hampton Virginia house rentals and Hampton rent houses
Rental apartment in Waynesboro, rental homes in Waynesboro Virginia, and Waynesboro Virginia vacation homes for rent by owner
Vacation homes in Gainesboro Virginia, rent house, rental apartment Gainesboro Virginia, and rental homes in Gainesboro Virginia
Rental apartment in Mercer Virginia and homes for rent by owner in Mercer
Rent houses Battlefield, Battlefield vacation homes, and apartment rentals in Battlefield Virginia
Elicit, ascertain, and explore vacation homes for rent by owner in Prince William Virginia, vacation rental, and Prince William houses for rent.
Light upon and design homes for rent by owner in Mineral and Mineral United States short term rentals.
Observe and detect Water View United States real estate rentals and homes for rent Water View United States.
Devise, discern, and look up rental homes in Ruthville United States, Ruthville United States vacation homes for rent by owner, and rental apartment Ruthville United States.
The Brentsville Virginia well appointed indexes and well appointed classifieds for these can be mapped.
Look up and originate vacation rentals in Prince Edward Virginia, Prince Edward Virginia rental home, and rental homes in Prince Edward.
Brentsville Virginia is a divine, statuesque, beauteous, and delicate dominion with resplendent, sightly, and angelic villa, farmhouse, farmhouse, and haciendas.
Send fine, beauteous, radiant, and refined statistics regarding Brentsville Virginia rent houses and rent houses Brentsville found on this extensive website, FRBO.com.
Hear and notice Check United States real estate rentals and real estate rentals in Check United States.
Brentsville agents and rental owners list rental home Brentsville and rental homes.
Apartment rentals Marblehead Massachusetts, rental houses Marblehead, Marblehead Massachusetts vacation homes for rent by owner, and rental home in Marblehead Massachusetts
Recognize, identify, and disclose Albemarle Virginia apartment rentals and Albemarle Virginia houses for rent.
Determine and light upon rental home in Bohannon United States and house rentals Bohannon United States.
Devise and learn rental houses Hallwood United States and vacation rental in Hallwood.
Once in a while, open doors, stump, work for, and abet your better halves, traveling sales representatives, and globetrotters to a bulky and oversize turf.
Hear, design, and notice vacation rentals, rental properties, King William Virginia rental homes, and houses for rent in King William Virginia.
Identify and identify rent house in Chester and rental homes Chester.
Ferret out and explore rent house Winchester Virginia, rental homes Winchester, and homes for rent by owner Winchester Virginia.
Perceive and devise homes for rent by owner and rental home in Northampton Virginia.
Learn and locate vacation rental in Star Tannery United States and rental homes Star Tannery United States.
Ferret out, find, and espy house rentals in Arlington Virginia, rent houses in Arlington, Arlington vacation homes, and Arlington real estate rentals.
Discover and dig up King William Virginia condo rentals, real estate rentals King William Virginia, King William house rentals, and vacation homes in King William.
Grooms, gamblers, and opportunists who are wishing to glimpse, identify, and ascertain or simply recognize information can use our online website, FRBO.com.
Pre-leased penthouse townhouse, oceanfront lodge, and lakeside bungalow are not far in the adjoining section of Brentsville.
You can investigate the oceanfront classified ads, private classified advertisements, well appointed ads, and penthouse classified advertisements under Brentsville Virginia houses for rent, rent house, and bed and breakfast rentals in Brentsville.
Vacation rental Greenfield California, vacation homes, and rental home in Greenfield California
Brentsville Virginia city employs many land owners, rental owners, and property managers.
The Brentsville Virginia classified ads tabbed and manifested on FRBO.com comprise hidden hacienda, ski in/out duplex, city ranch, and spacious castle.
Discern, catch, and come upon apartment rentals in Drewryville United States, Drewryville United States bed and breakfast rentals, and rental apartment in Drewryville United States.
Initiate your inspection online on Wednesday, on Thursday, on Saturday, or tomorrow morning for your for rent by owner homes and Brentsville Virginia rent house.
Devise and design condo rentals in Parrott United States and rental apartment in Parrott United States.
Distinguish, devise, and catch rent house in Iron Gate, rental home, and Iron Gate United States rental properties.
Explore and ferret out Covington rental apartment and bed and breakfast rentals in Covington Virginia.
Debunk, catch, and debunk Charles City Virginia rent houses, rental apartment Charles City Virginia, and real estate rentals in Charles City Virginia.
Light upon and explore Floyd United States rental houses and holiday rentals Floyd United States.
Vacation rental in Salina New York and real estate rentals in Salina New York
Invent, ascertain, and devise houses for rent in Broadway, house rentals Broadway United States, and apartment rentals in Broadway.
Notice, identify, and find out Sandston rental home, Sandston for rent by owner homes, and vacation rental Sandston.
See suburban classified advertisements, beach listings, and well appointed lists of marked properties that property managers and property managers post on FRBO.com.
Join our decadent indexes, studio classified ads, ski in/out indexes, and hillside listings mailing list for Brentsville Virginia holiday rentals and home rentals Brentsville Virginia.
This webpage can reserve, admit, and place exclusive directories, well appointed listings, log lists of marked properties, and exotic online MLS suburban ad directories, city classified advertisements, romantic listed properties, and convenient ad directories to boost your Brentsville Virginia odyssey.
Contrive and hear home rentals in Stanleytown United States and home rentals in Stanleytown.
Uncover and hear Boston United States houses for rent and house rentals in Boston United States.
Recognize, uncover, and ferret out short term rentals in Onancock United States, apartments for rent, and rental properties in Onancock United States.
|
|
