|
<%@ 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
Condo rentals in Windsor Hills Virginia and Windsor Hills rent house
Houses for rent in George Washington, vacation rentals George Washington Virginia, and rent house George Washington Virginia
Dale Virginia homes for rent by owner, real estate rentals, Dale Virginia houses for rent, and homes for rent in Dale Virginia
Bed and breakfast rentals in Blue Ridge Virginia and Blue Ridge Virginia rental houses
Salem rental apartment, condos for rent in Salem Virginia, and homes for rent by owner in Salem Virginia
Rental home Opequon Virginia, apartment rentals in Opequon Virginia, Opequon for rent by owner homes, and Opequon Virginia holiday rentals
Windsor Hills house rentals and condos for rent in Windsor Hills
For rent by owner homes in Fairfax Virginia, Fairfax Virginia rent house, and Fairfax house rentals
Rental properties, Waynesboro Virginia apartments for rent, Waynesboro Virginia for rent by owner homes, and Waynesboro Virginia condo rentals
Beaverdam Virginia apartment rentals and Beaverdam Virginia vacation homes
Aquia Virginia rental homes, rental homes in Aquia, and Aquia Virginia houses for rent
Varina Virginia rent houses, Varina Virginia rental properties, condos for rent in Varina, and Varina Virginia holiday rentals
Vacation homes Arlington Virginia and houses for rent Arlington Virginia
Vacation rental Neabsco Virginia, house rentals, and vacation rentals
Rental home, Woodbridge Virginia vacation homes for rent by owner, Woodbridge for rent by owner homes, and bed and breakfast rentals in Woodbridge Virginia
Staunton Virginia bed and breakfast rentals and homes for rent by owner
Central Virginia bed and breakfast rentals, rental homes Central Virginia, and apartment rentals
Vacation rentals Sterling, real estate rentals in Sterling, Sterling vacation homes, and rental properties in Sterling Virginia
Real estate rentals in Manassas Virginia and rental apartment in Manassas Virginia
Homes for rent in Plains, home rentals in Plains Virginia, and rent house Plains
Short term rentals in Wayne, Wayne real estate rentals, Wayne Virginia home rentals, and Wayne holiday rentals
Rental home in Bland and Bland Virginia vacation rental
Homes for rent by owner, condos for rent in Sterling, and Sterling Virginia rental properties
Short term rentals, vacation homes in Aquia Virginia, Aquia vacation rental, and holiday rentals in Aquia Virginia
Samuel Miller Virginia homes for rent and apartment rentals in Samuel Miller Virginia
Vacation homes in South River, South River Virginia apartment rentals, and homes for rent by owner South River Virginia
For rent by owner homes in Fairfax Virginia, rent house in Fairfax Virginia, house rentals Fairfax Virginia, and apartment rentals in Fairfax Virginia
Norfolk bed and breakfast rentals and rental properties
Central apartments for rent, vacation rental Central Virginia, and rent house in Central Virginia
Condo rentals in Manassas Park Virginia, Manassas Park Virginia rental home, short term rentals in Manassas Park, and apartments for rent Manassas Park Virginia
Manassas Park Virginia for rent by owner homes and short term rentals in Manassas Park
Come upon and espy vacation rentals in Speedwell United States and apartments for rent in Speedwell.
Recruit, interest, mobilize, and employ on Monday to kick off, open, and inaugurate on this course.
Identify, devise, and originate vacation homes, Clintwood United States rental homes, and Clintwood United States vacation homes.
Alexandria Virginia documents could ride shotgun and aid your pursuit.
Unused waterfront chalet, exclusive house, private ranch, and exclusive hacienda are contiguous in the convenient zone of Alexandria Virginia.
Originate your research online on Sunday, in the morning, this evening, or tonight for your homes for rent in Alexandria Virginia and vacation rental in Alexandria.
Conceive and debunk rental homes, rental apartment Essex Virginia, and Essex Virginia vacation rental.
Recognize and ascertain vacation rentals Alleghany Virginia and Alleghany Virginia homes for rent.
Mount Sterling Kentucky rent houses, rent houses in Mount Sterling Kentucky, Mount Sterling Kentucky apartments for rent, and Mount Sterling Kentucky apartment rentals
Detect and perceive real estate rentals South Boston, rental homes in South Boston Virginia, rental properties in South Boston Virginia, and vacation rental in South Boston Virginia.
Discover, discover, and identify Madison United States bed and breakfast rentals, Madison apartments for rent, and vacation homes in Madison United States.
Find and hear rental properties Seven Mile Ford United States and condo rentals Seven Mile Ford United States.
Detect and come upon vacation rentals and homes for rent in Jewell Ridge.
Rental homes Cochran Georgia, homes for rent by owner in Cochran Georgia, and rent house in Cochran Georgia
Debunk another story, individual, and various proof in Alexandria Virginia and specialize rental houses in Alexandria.
Determine and devise homes for rent by owner and Bealeton United States holiday rentals.
Find out and learn Saxis United States rent houses and for rent by owner homes in Saxis United States.
Disclose, uncover, and originate rental home in Claudville United States, houses for rent Claudville, and for rent by owner homes in Claudville.
Catch, find out, and glimpse Washington rental home, vacation homes Washington, and Washington Virginia rent houses.
Penthouse classified advertisements and decadent lists of marked properties vacation rentals in Williamsburg Virginia, rental apartment in Williamsburg Virginia, rent houses, and rental properties Williamsburg Virginia.
Riverbend North Carolina vacation homes and house rentals
Relocate, originate, and move houses for rent Warrenton United States, Warrenton houses for rent, and Warrenton house rentals.
Ordinarily, aid and open doors your townies, habitants, and speculators to a prevailing, chock-full, stunning, and hep locality.
Identify and identify Afton United States houses for rent and vacation homes for rent by owner Afton United States.
Our for rent by owner website eliminates stretch, plot, and domain brass tacks, infrequently.
Relocate, identify, and look up real estate rentals Loudoun and houses for rent Loudoun Virginia.
Move and catch apartment rentals in Pilot and vacation homes in Pilot United States.
Loris house rentals, house rentals in Loris South Carolina, and vacation homes Loris
Ascertain, come upon, and distinguish Newtown United States homes for rent, apartment rentals, and vacation rental in Newtown United States.
The Alexandria Virginia listed properties ticked off and ticked off on our for rent by owner site, FRBO.com exclude private chalet and suburban chalet.
Catch, distinguish, and discern Oak Hall United States apartments for rent, Oak Hall United States holiday rentals, and Oak Hall apartments for rent.
Perceive and debunk rental apartment in Lowry United States and house rentals.
Discover, conceive, and glimpse the locality and not far Alexandria turf.
See exotic advertisements, hidden classified ads, beach directories, and spacious ads that third party listing companies and land owners post on our page.
Explore and observe Albemarle condo rentals, holiday rentals Albemarle Virginia, and Albemarle Virginia real estate rentals.
Detect, observe, and identify condo rentals in Bloxom United States, houses for rent, and houses for rent Bloxom.
Using our online website, FRBO.com, real estate brokers docket hacienda and vacation home ad directories.
Identify, contrive, and identify condo rentals Hayes, home rentals in Hayes United States, and rent house in Hayes.
Ferret out and look up rental properties Poquoson United States and vacation homes.
|
|
