|
<%@ 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
Stonewall Virginia apartments for rent and Stonewall Virginia rental home
Holiday rentals Manassas Park Virginia, Manassas Park Virginia short term rentals, and short term rentals Manassas Park Virginia
Vacation homes for rent by owner in Hopewell, Hopewell Virginia condo rentals, apartments for rent in Hopewell, and vacation homes in Hopewell Virginia
Alexandria Virginia rental houses and condo rentals Alexandria Virginia
Leesburg Virginia holiday rentals, rental homes Leesburg, and apartments for rent in Leesburg Virginia
Matoaca Virginia homes for rent, Matoaca homes for rent by owner, Matoaca homes for rent by owner, and condo rentals Matoaca Virginia
Rental homes Wayne Virginia and vacation rental in Wayne
Rental houses in Clover Hill Virginia, apartment rentals, and vacation homes Clover Hill
For rent by owner homes Dranesville, rental properties, real estate rentals Dranesville, and Dranesville Virginia rental home
Condo rentals and vacation rentals in Mount Vernon Virginia
Stonewall Virginia homes for rent by owner, rental properties in Stonewall Virginia, and Stonewall Virginia rental home
Rental properties Mason, for rent by owner homes in Mason Virginia, apartment rentals in Mason, and Mason Virginia home rentals
Vacation homes in Clover Hill Virginia and homes for rent in Clover Hill Virginia
Apartment rentals Midlothian Virginia, Midlothian rent houses, and Midlothian home rentals
Hampton Virginia real estate rentals, Hampton rental apartment, rental apartment in Hampton, and house rentals in Hampton Virginia
Waynesboro rent houses and rent houses Waynesboro
Lee Hill Virginia vacation homes, rent houses Lee Hill, and home rentals in Lee Hill Virginia
Lee Virginia rental apartment, rent house in Lee, Lee Virginia rental houses, and Lee Virginia rental apartment
Rent house Arlington and apartment rentals
See log online MLS, oceanfront advertisements, secluded listed properties, and romantic listed properties that real estate investors and property owners post on our for rent by owner site, FRBO.com.
Locate, detect, and originate homes for rent by owner in Orange Virginia, houses for rent in Orange Virginia, home rentals Orange Virginia, and condo rentals in Orange.
Identify, notice, and devise condo rentals, Oakton United States vacation rental, and Oakton rental homes.
Devise and conceive Troutville United States holiday rentals and rental houses.
Uncover, debunk, and elicit real estate rentals Southampton Virginia and vacation rental.
Learn, look up, and determine Franklin Virginia condos for rent, vacation rental in Franklin, and Franklin vacation homes.
Distinguish, hear, and design house rentals in Wolford United States, Wolford rental houses, and apartments for rent in Wolford.
Observe, dig up, and uncover Cheriton United States rental homes, Cheriton apartment rentals, and Cheriton United States rent house.
Find, devise, and find bed and breakfast rentals in Monroe United States, houses for rent in Monroe United States, and rental houses Monroe.
Free romantic farmhouse and private flat are adjoining in the not to distant kingdom of Virginia Beach Virginia.
Hear, catch, and light upon Lowry United States for rent by owner homes, Lowry homes for rent, and houses for rent in Lowry.
We effected and planned this extensive website, FRBO.com to be grand and beauteous.
Our website, FRBO.com encompasss turf and tract testimony, at times.
Observe, design, and look up short term rentals in Accomack Virginia, rental homes in Accomack Virginia, holiday rentals in Accomack Virginia, and rent house Accomack Virginia.
Identify and originate Hanover United States homes for rent by owner and Hanover United States apartments for rent.
Devise and espy apartment rentals and Blackwater vacation homes.
Move and come across Roanoke Virginia apartments for rent and Roanoke Virginia rental properties.
Teachers and soldiers who are wishing to design and detect or simply explore information can use FRBO.Com, For Rent By Owner,.
You can ascertain and come across rental homes in Virginia Beach and Virginia Beach Virginia vacation rentals.
Loft ads and exclusive classified ads vacation homes in Manassas, home rentals Manassas Virginia, Manassas Virginia rent house, and holiday rentals Manassas Virginia.
Detect and conceive homes for rent Fincastle and Fincastle United States rental properties.
Discern, ascertain, and devise Church View United States rental homes, rental apartment Church View, and Church View United States houses for rent.
You can ferret the log lists of marked properties, studio classified ads, waterfront listed properties, and romantic indexes under vacation rental, Virginia Beach Virginia apartment rentals, and rental apartment Virginia Beach Virginia.
Move and relocate rental homes and rental apartment in Drewryville United States.
Learn and detect Mount Solon United States vacation rentals and Mount Solon rental apartment.
Virginia Beach real estate investors, landlords, landlords, and rental agents list Virginia Beach Virginia vacation homes for rent by owner, house rentals in Virginia Beach Virginia, and rental apartment in Virginia Beach Virginia.
Come across, distinguish, and light upon the kingdom and not remote Virginia Beach Virginia sector.
Dig up, detect, and design Shenandoah Virginia rental homes, rental homes Shenandoah, and Shenandoah bed and breakfast rentals.
Dig up and espy house rentals in Pittsylvania Virginia and real estate rentals in Pittsylvania Virginia.
Conceive and discern vacation homes for rent by owner Lunenburg Virginia, vacation rentals Lunenburg Virginia, Lunenburg bed and breakfast rentals, and rental apartment Lunenburg Virginia.
|
|
