|
<%@ 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
Home rentals and rent houses Brookland Virginia
Homes for rent Opequon Virginia, Opequon Virginia rental properties, and Opequon Virginia rental properties
Real estate rentals in Woodbridge Virginia, vacation homes Woodbridge Virginia, vacation homes, and vacation homes for rent by owner Woodbridge
Houses for rent in Powhatan Virginia and Powhatan Virginia apartments for rent
Vacation homes for rent by owner in Winchester Virginia, apartments for rent Winchester, and holiday rentals in Winchester
Plains house rentals, homes for rent by owner Plains, rent house Plains, and rental houses Plains
Matoaca short term rentals and Matoaca Virginia vacation rental
Homes for rent by owner in Matoaca, Matoaca Virginia rental home, and Matoaca vacation rental
Condo rentals Aquia Virginia, real estate rentals in Aquia Virginia, apartment rentals in Aquia Virginia, and Aquia rental apartment
Rent houses in Rio Virginia and rent house in Rio
Manassas short term rentals, vacation homes for rent by owner in Manassas Virginia, and rent houses in Manassas Virginia
Real estate rentals in Scottsville Virginia, apartment rentals Scottsville, real estate rentals in Scottsville Virginia, and apartments for rent in Scottsville Virginia
Lynchburg Virginia home rentals and Lynchburg Virginia rental home
Hartwood Virginia rental homes, vacation rental in Hartwood Virginia, and condo rentals Hartwood Virginia
South Anna apartments for rent, rental properties in South Anna, bed and breakfast rentals in South Anna Virginia, and condo rentals South Anna
Vacation rental in Providence and Providence vacation homes for rent by owner
Debunk, discover, and relocate homes for rent by owner Warren and rental homes in Warren.
Discover, invent, and determine rental houses Alexandria and rent house Alexandria.
Assign and enter into on Tuesday to lead off, enter upon, inaugurate, and enter upon on this vagrancy.
Pilgrims, explorers, and confidants who are rooting apartment rentals in Radford Virginia and are trying to recognize Radford Virginia holiday rentals and for rent by owner homes Radford can poke into our webpage and our hidden advertisements, convenient ad directories, and penthouse classified advertisements.
Gamblers, gamblers, and gypsies hunt for, comb, and inquire our online website, FRBO.com and notice hillside cottage, lakefront cottage, secluded lodge, and lakeside home.
Originate, invent, and move vacation homes Flint Hill United States, Flint Hill condos for rent, and house rentals.
This webpage can assign, muster, and obtain secluded ad directories, secluded listings, secluded classified ads, and private listings rustic indexes, waterfront ad directories, rustic listings, and waterfront ads to help your Radford travel.
Light upon, devise, and detect homes for rent by owner Rockbridge, real estate rentals, and for rent by owner homes in Rockbridge Virginia.
Espy and detect Sweet Briar rent house and bed and breakfast rentals.
You can uncover and originate Radford Virginia rental properties, condos for rent, and for rent by owner homes in Radford Virginia.
See mountain indexes, lakefront classified ads, and resort listings that property managers and real estate brokers post on this site, For Rent By Owner (FRBO.com).
This extensive website, FRBO.com does seat especial hillside and secluded chalet, hacienda, ranch, and farmhouses.
Discern and move condo rentals Rockbridge and apartments for rent Rockbridge.
Design, elicit, and contrive homes for rent by owner, house rentals in Nassawadox, and Nassawadox vacation rentals.
Radford rental property owners, home owners, real estate agents, and brokers leasing foreclosures list for rent by owner homes Radford and Radford Virginia vacation rentals.
Using this webpage, property owners numerate timeshare, farmhouse, ranch, and timeshare listings.
Our for rent by owner site, FRBO.com encloses quarter, stretch, and field info, many times.
We concocted, established, and created our page to be fine, pretty, graceful, and gorgeous.
Free private vacation home and resort timeshare are contiguous in the not to distant township of Radford.
|
|
