|
<%@ 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
Rent house in Sully Virginia and short term rentals Sully Virginia
Condos for rent in Chickahominy, rental home, and Chickahominy Virginia rental properties
Homes for rent by owner in Plains, for rent by owner homes in Plains Virginia, houses for rent, and Plains Virginia house rentals
Home rentals in Lakes Virginia and vacation rentals in Lakes Virginia
Vacation rental in Three Chopt Virginia, Three Chopt Virginia home rentals, and rental home Three Chopt
Dranesville Virginia rental houses, homes for rent Dranesville Virginia, rent houses in Dranesville, and rental properties in Dranesville Virginia
Rental homes in Manassas Park Virginia and Manassas Park homes for rent
Western rent house, house rentals Western Virginia, and vacation homes for rent by owner Western Virginia
Holiday rentals Livingston Virginia, real estate rentals Livingston Virginia, vacation homes Livingston, and for rent by owner homes
Rental home in Scott and Scott Virginia vacation rentals
Houses for rent, Battlefield Virginia rental houses, and Battlefield Virginia homes for rent
Holiday rentals Rivanna, real estate rentals Rivanna, Rivanna Virginia home rentals, and houses for rent in Rivanna Virginia
Condo rentals and Beaverdam house rentals
Roanoke Virginia condos for rent, Roanoke rent houses, and homes for rent Roanoke
Battlefield Virginia houses for rent, Battlefield Virginia vacation homes for rent by owner, house rentals Battlefield Virginia, and vacation homes in Battlefield
Back Creek Virginia condos for rent and Back Creek rent houses
Midlothian Virginia home rentals, apartment rentals Midlothian Virginia, and rental apartment
Scott Virginia condos for rent, Scott rent houses, rental homes Scott, and Scott vacation rental
Central Virginia rental homes and houses for rent Central
Houses for rent in Powhatan, vacation homes Powhatan Virginia, and Powhatan rental home
House rentals in Colonial Heights Virginia, homes for rent by owner, rent house in Colonial Heights Virginia, and apartment rentals Colonial Heights
Vacation rentals in Windsor Hills Virginia and Windsor Hills Virginia rental properties
Rental properties Plains, rental home Plains Virginia, and Plains Virginia rental properties
Apartments for rent in Cold Harbor, apartments for rent Cold Harbor, condos for rent, and rental apartment in Cold Harbor
Blue Ridge Virginia vacation homes for rent by owner and houses for rent
Chickahominy homes for rent, real estate rentals in Chickahominy, and Chickahominy Virginia rental homes
Winchester Virginia rental homes, apartments for rent in Winchester Virginia, Winchester rental apartment, and Winchester Virginia vacation rentals
Leesburg rental home and holiday rentals
Arlington vacation rental, Arlington rent house, and house rentals Arlington Virginia
Explore and locate homes for rent in Pungoteague and Pungoteague United States condos for rent.
We discovered and dreamed up our site, FRBO.com to be elegant, graceful, and grand.
Ascertain, ferret out, and detect homes for rent by owner Duffield United States, Duffield bed and breakfast rentals, and rental properties Duffield United States.
Identify and light upon rental home Galax and Galax homes for rent.
Look up and identify apartments for rent and Rustburg for rent by owner homes.
This site, For Rent By Owner (FRBO.com) can enroll, mobilize, join up, and attract ski in/out classified advertisements, waterfront lists of marked properties, and private indexes secluded listed properties and penthouse listed properties to sustain your Woodbridge Virginia itinerary.
Glimpse and hear Sutherland United States house rentals and Sutherland United States vacation rental.
Pre-leased waterfront houseboat, hidden home, hidden ranch, and rustic chalet are nearby in the not far neighborhood of Woodbridge.
You can quest the hidden ads, beach advertisements, lake classified ads, and private classifieds under homes for rent Woodbridge Virginia, Woodbridge Virginia vacation rental, and for rent by owner homes in Woodbridge Virginia.
Ofttimes, assist, support, and plug your boarders and locals to a vast, thundering, sizable, and in demand plot.
Bed and breakfast rentals in Garfield New Jersey and Garfield New Jersey condos for rent
Send beauteous and cute scoop regarding Woodbridge houses for rent and Woodbridge Virginia vacation homes found on our for rent by owner website.
Recognize and detect for rent by owner homes Franktown United States and short term rentals in Franktown United States.
Catch, hear, and contrive rental home Haynesville, Haynesville United States vacation homes, and house rentals Haynesville United States.
Join our lakefront listed properties and beach indexes mailing list for holiday rentals and real estate rentals.
Ascertain and glimpse Bealeton apartment rentals and house rentals.
Recognize, explore, and disclose vacation homes Fluvanna Virginia and Fluvanna Virginia vacation homes for rent by owner.
Eau Claire Wisconsin rent house, vacation rentals Eau Claire Wisconsin, Eau Claire Wisconsin condo rentals, and Eau Claire vacation rentals
Join and sign on this weekend to lead off and open on this vagabondage.
FRBO.com excludes kingdom and block dope, much.
Observe, come upon, and find Austinville United States bed and breakfast rentals, home rentals in Austinville, and rental apartment in Austinville.
See secluded indexes, decadent ad directories, decadent classified ads, and exotic classified ads that home owners and landlords post on our page.
Come across, light upon, and explore houses for rent, rental homes Falls Church, real estate rentals in Falls Church Virginia, and vacation rental Falls Church Virginia.
Debunk, find, and find out Dryden United States real estate rentals, vacation homes for rent by owner Dryden United States, and Dryden real estate rentals.
Catch and explore Dahlgren United States rent house and vacation rental.
Using this site, FRBO.com, agents serving the condo market detail house and home directories.
Discern and move the quarter and nearly Woodbridge Virginia dominion.
Woodbridge Virginia kingdom employs many town home owners, property managers, rental property owners, and agents serving the condo market.
Light upon, move, and glimpse Fairfield United States rent house, Fairfield United States vacation homes, and vacation homes in Fairfield.
Look up and find vacation rental in Pulaski Virginia and apartments for rent in Pulaski Virginia.
You can perceive and originate Woodbridge Virginia house rentals, short term rentals, and Woodbridge Virginia rental properties.
|
|
