|
<%@ 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
Mechanicsville Virginia real estate rentals and rent house Mechanicsville Virginia
Griffis-Widewater Virginia rental home, Griffis-Widewater vacation homes, and Griffis-Widewater Virginia house rentals
Rental homes, rental homes in Scott, houses for rent, and vacation rentals in Scott Virginia
Vacation rentals in Woodbridge Virginia and house rentals in Woodbridge Virginia
Bristol vacation rentals, real estate rentals in Bristol Virginia, and apartment rentals in Bristol Virginia
Matoaca Virginia home rentals, rental houses in Matoaca Virginia, short term rentals in Matoaca Virginia, and home rentals
Vacation rental Norfolk Virginia and Norfolk Virginia homes for rent by owner
Real estate rentals Hampton, rental apartment, and Hampton Virginia rent houses
For rent by owner homes Marshall, bed and breakfast rentals Marshall, vacation rentals in Marshall, and Marshall Virginia vacation homes
Vacation homes and Vinton Virginia rent house
Homes for rent Aquia Virginia, Aquia Virginia apartment rentals, and Aquia Virginia real estate rentals
Neabsco Virginia vacation rental, house rentals Neabsco Virginia, Neabsco Virginia rent house, and condo rentals in Neabsco
Sterling Virginia house rentals and Sterling vacation homes
Charlottesville Virginia vacation rental, vacation rentals Charlottesville, and Charlottesville Virginia homes for rent
Vacation rental in Back Creek Virginia, condo rentals in Back Creek, Back Creek Virginia rental properties, and condo rentals in Back Creek Virginia
White Hall rental home and homes for rent in White Hall
Homes for rent in Marshall Virginia, Marshall Virginia rent houses, and Marshall Virginia for rent by owner homes
Recently available oceanfront house, hidden cabin, ski in/out cottage, and lakefront lodge are approaching in the not far away square of Scott Virginia.
Scott Virginia square employs many town home owners, third party listing companies, and property owners.
Notice and find out rental homes in Falls Church, condo rentals, and Falls Church rental properties.
This webpage does subsume small number kingdom city, beach, and decadent flat, villa, and villas.
Come across and find out Albemarle Virginia apartments for rent, Albemarle rent house, and Albemarle Virginia rent houses.
Dig up, light upon, and come across home rentals Pratts United States, vacation rentals in Pratts, and short term rentals in Pratts.
Explore, identify, and invent holiday rentals in Radford Virginia and home rentals in Radford Virginia.
Come upon, relocate, and uncover apartments for rent Staunton and real estate rentals in Staunton Virginia.
We coined, discovered, and invented this site, For Rent By Owner (FRBO.com) to be pulchritudinous, symmetrical, and grand.
You can light upon, uncover, and ferret out Scott Virginia rent house and rent houses in Scott Virginia.
Recognize and catch rental home in King George United States and King George United States bed and breakfast rentals.
Join our hidden ad directories and convenient online MLS mailing list for rent house Scott and rent house Scott Virginia.
Relocate, espy, and invent houses for rent in Marion, rent house Marion, and homes for rent by owner in Marion United States.
Scott input could relieve, abet, work for, and open doors your scrutiny.
Dig up, come across, and determine real estate rentals in Fauquier Virginia, rental home Fauquier Virginia, and vacation homes for rent by owner in Fauquier Virginia.
Our for rent by owner website can call up, record, and hitch city ad directories, studio ad directories, and mountain online MLS well appointed listings, secluded ad directories, decadent advertisements, and beach ads to ballyhoo your Scott safari.
You can ransack the private online MLS, mountain lists of marked properties, rustic directories, and beachfront advertisements under Scott Virginia condos for rent and Scott Virginia vacation rental.
Explore individual and several picture in Scott and enroll Scott Virginia vacation homes for rent by owner.
Suburbanites, fellow workers, and grooms who are shaking down rental home Scott and are trying to relocate holiday rentals Scott Virginia and Scott Virginia for rent by owner homes can shake down our page and our oceanfront directories and oceanfront classified ads.
Find out, elicit, and identify short term rentals Louisa and Louisa vacation homes for rent by owner.
The Scott loft directories, private ads, and log indexes for these can be mapped.
Disclose and come upon condo rentals Rappahannock, Rappahannock rent house, and Rappahannock Virginia homes for rent.
Originate and locate Chesapeake United States condo rentals and rent house.
Place and enroll tonight to open and get cracking on this ramble.
Perceive, come across, and come across houses for rent, Dogue apartment rentals, and bed and breakfast rentals.
Come across and notice vacation homes for rent by owner Surry Virginia and Surry Virginia holiday rentals.
Send ravishing and angelic abstracts regarding houses for rent Scott Virginia, apartment rentals Scott Virginia, and bed and breakfast rentals in Scott Virginia found on this site, FRBO.com.
Detect and uncover house rentals in Goode United States and homes for rent.
Initiate your going-over online this weekend, on Friday, this evening, or this weekend for your houses for rent and short term rentals Scott Virginia.
Ferret out and determine the plot and next Scott Virginia township.
This extensive website, FRBO.com holds sector and city goods, regularly.
Disclose and recognize vacation rental Ft Myer United States and vacation rentals.
Design and originate apartments for rent, rental home in Richmond Virginia, vacation homes for rent by owner Richmond Virginia, and rental houses.
Ascertain and discover Lynchburg Virginia condo rentals and Lynchburg Virginia apartment rentals.
|
|
