|
<%@ 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
Waynesboro Virginia vacation rental and Waynesboro Virginia rental home
Rental houses, vacation rental in Mason Virginia, and house rentals
House rentals Back Creek Virginia, real estate rentals in Back Creek Virginia, Back Creek rental home, and Back Creek Virginia rental apartment
Rent houses and Stonewall Virginia vacation homes
Lynchburg Virginia home rentals, rental apartment in Lynchburg Virginia, and Lynchburg Virginia house rentals
Beaverdam Virginia bed and breakfast rentals, apartment rentals, home rentals, and apartment rentals Beaverdam Virginia
Vacation rentals and house rentals Roanoke Virginia
Vacation rental in Harrisonburg Virginia, vacation homes in Harrisonburg, and real estate rentals in Harrisonburg
House rentals in Sully Virginia, Sully Virginia homes for rent by owner, Sully Virginia bed and breakfast rentals, and house rentals in Sully
Opequon Virginia holiday rentals and vacation rentals in Opequon Virginia
Rental houses in Waynesboro Virginia, vacation rental in Waynesboro Virginia, and holiday rentals Waynesboro
Rent houses Gainesville, rental apartment in Gainesville Virginia, Gainesville bed and breakfast rentals, and Gainesville Virginia condo rentals
Rent houses Neabsco and for rent by owner homes in Neabsco Virginia
Real estate rentals Colonial Heights Virginia, condos for rent in Colonial Heights, and Colonial Heights Virginia for rent by owner homes
Apartments for rent in Vinton Virginia, condos for rent in Vinton, homes for rent by owner Vinton, and for rent by owner homes in Vinton
For rent by owner homes in Neabsco and rental houses in Neabsco
White Hall property managers, agents serving the condo market, real estate brokers, and condo owners list White Hall vacation rentals and rent houses White Hall Virginia.
Pioneers, salesmen, and brothers who are searching for homes for rent in White Hall and are trying to dig up White Hall vacation rental, short term rentals, and White Hall Virginia rental home can inspect our site, FRBO.com and our lakefront classifieds, ski in/out ad directories, and lakeside ad directories.
Our site, FRBO.com haves township, county, and turf details, often.
Catch and originate for rent by owner homes in Ruckersville United States and rental apartment in Ruckersville.
The White Hall Virginia ad directories recorded and registered on our for rent by owner website except beach ranch and exotic cabin.
White Hall plot employs many landlords, real estate brokers, and real estate agents.
You can dig up, notice, and look up White Hall Virginia vacation rentals, houses for rent, and for rent by owner homes in White Hall.
Our online website, FRBO.com can levy, serve, and reserve ski in/out classified ads, suburban ad directories, lakefront classified ads, and lakeside ad directories beachfront classified advertisements and oceanfront advertisements to run interference your White Hall Virginia tramp.
Come upon and come across Clifton Forge vacation rental and Clifton Forge Virginia for rent by owner homes.
Observe and espy vacation rental in Prince George Virginia and condos for rent in Prince George.
Observe and come upon real estate rentals Cross Junction and homes for rent by owner in Cross Junction.
Occupiers, tourists, and pilgrims hunt and scour our online website, FRBO.com and ferret out lake vacation home, exclusive apartment, lake timeshare, and well appointed farmhouse.
White Hall Virginia testimony could hype and plug your investigation.
We forged and occasioned For Rent By Owner to be comely, nice, and exquisite.
Detect, move, and design Hiltons United States house rentals, Hiltons rental houses, and apartments for rent in Hiltons.
Identify and elicit Esmont United States short term rentals and vacation rental Esmont.
Using this extensive website, FRBO.com, landlords schedule condominium and bungalow ads.
Find out and conceive Lively United States apartment rentals and rental home Lively United States.
Send good-looking and dazzling picture regarding White Hall Virginia real estate rentals, bed and breakfast rentals White Hall, and vacation rentals in White Hall Virginia found on our site, FRBO.com.
Elicit, observe, and glimpse home rentals in Battery Park United States, homes for rent by owner in Battery Park, and vacation homes Battery Park.
Determine, distinguish, and determine Weyers Cave homes for rent by owner, rent house in Weyers Cave United States, and Weyers Cave United States vacation rental.
|
|
