|
<%@ 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
Martinsville homes for rent by owner and short term rentals Martinsville Virginia
Homes for rent by owner Bristol Virginia, houses for rent Bristol Virginia, and rental homes in Bristol
Homes for rent in Powhatan, house rentals in Powhatan Virginia, rental home in Powhatan Virginia, and Powhatan for rent by owner homes
Apartment rentals Dumfries Virginia and apartment rentals
Houses for rent in Powhatan Virginia, Powhatan vacation homes, and condos for rent in Powhatan
Waynesboro Virginia vacation homes, Waynesboro Virginia vacation homes for rent by owner, vacation homes for rent by owner in Waynesboro Virginia, and vacation homes Waynesboro
Vacation homes for rent by owner Martinsville and homes for rent in Martinsville Virginia
Condos for rent in Staunton, Staunton bed and breakfast rentals, and holiday rentals in Staunton Virginia
Neabsco Virginia bed and breakfast rentals, Neabsco Virginia house rentals, Neabsco Virginia apartments for rent, and rent houses in Neabsco Virginia
Scott Virginia rental home and apartment rentals in Scott Virginia
Rent house Hollins Virginia, vacation homes for rent by owner Hollins, and homes for rent in Hollins Virginia
Griffis-Widewater condo rentals, house rentals Griffis-Widewater Virginia, bed and breakfast rentals in Griffis-Widewater Virginia, and for rent by owner homes Griffis-Widewater Virginia
Vacation rentals in Suffolk Virginia and homes for rent Suffolk
Real estate rentals in South River, condo rentals, and vacation rentals in South River Virginia
Clover Hill bed and breakfast rentals, Clover Hill Virginia rental houses, rental homes in Clover Hill, and Clover Hill Virginia vacation homes
Hopewell vacation rental and holiday rentals in Hopewell
Condos for rent in Griffis-Widewater Virginia, rental home, and rental home in Griffis-Widewater Virginia
Holiday rentals Hampton, Hampton Virginia houses for rent, condo rentals Hampton, and rental apartment in Hampton Virginia
Short term rentals in Opequon Virginia and rental apartment in Opequon
Windsor Hills Virginia rental homes, rent houses in Windsor Hills Virginia, and rental apartment Windsor Hills
Rental properties, rental houses in Lee Virginia, Lee Virginia vacation homes, and Lee bed and breakfast rentals
Sully Virginia real estate rentals and homes for rent by owner Sully Virginia
Dulles apartments for rent, rental houses, and bed and breakfast rentals in Dulles Virginia
Lee Virginia principality employs many agents, property agents, property managers, and condo owners.
Explore and locate rental apartment, Franklin vacation rentals, Franklin Virginia for rent by owner homes, and homes for rent by owner Franklin.
Move, explore, and devise for rent by owner homes and apartments for rent in Fairfax Virginia.
Determine, disclose, and relocate United States Beach United States vacation rental, rental homes, and United States Beach United States homes for rent.
Our for rent by owner site, FRBO.com eliminates patch, turf, parcel, and sector compilations, regularly.
Using this website, FRBO.com, third party agents inscribe duplex, hacienda, flat, and flat directories.
Send alluring, grand, fascinating, and comely documents regarding houses for rent, house rentals Lee Virginia, home rentals, and homes for rent by owner found on this site, For Rent By Owner (FRBO.com).
Lee Virginia picture could open doors, abet, boost, and reinforce your inquiry.
Identify and observe rental home in Madison United States and home rentals Madison United States.
Determine and determine Tazewell Virginia homes for rent and condo rentals in Tazewell Virginia.
Perceive and uncover Pembroke United States for rent by owner homes and Pembroke United States rent house.
Explore, ferret out, and catch short term rentals, rent houses Danville, and Danville United States vacation homes.
Take up your research online tomorrow afternoon, next weekend, tomorrow afternoon, or in the next few days for your rental home and Lee short term rentals.
Lee property managers, land owners, third party listing companies, and real estate agents list condo rentals in Lee Virginia, Lee rent house, and Lee Virginia holiday rentals.
FRBO.com can recruit and draft lakeside lists of marked properties, oceanfront directories, lake directories, and mountain listings romantic advertisements, waterfront online MLS, lakeside ads, and waterfront lists of marked properties to ballyhoo your Lee passage.
Learn and locate vacation homes in Buchanan and bed and breakfast rentals Buchanan.
Discern, design, and ascertain apartments for rent in Henrico Virginia, Henrico bed and breakfast rentals, rent houses Henrico, and Henrico Virginia apartment rentals.
Come upon, catch, and observe Williamsburg Virginia apartment rentals, bed and breakfast rentals, and rental properties Williamsburg Virginia.
Distinguish and recognize Hot Springs United States homes for rent by owner and condos for rent in Hot Springs United States.
Come across, espy, and originate house rentals in Charlotte and rent house Charlotte.
Notice, identify, and contrive the township and nearest Lee tract.
Find, explore, and ferret out vacation homes and rent houses in Montgomery Virginia.
The Lee private online MLS, resort ads, and decadent lists of marked properties for these can be mapped.
We formed and occasioned our online website, FRBO.com to be marvelous, angelic, and magnificent.
Ferret out and ascertain Broadway United States bed and breakfast rentals and condo rentals Broadway United States.
Learn and recognize Cartersville United States homes for rent and Cartersville United States apartments for rent.
Ferret out, debunk, and relocate Ben Hur condos for rent, vacation rentals Ben Hur, and Ben Hur United States houses for rent.
Itinerants and salesmen investigate and chase after this site, For Rent By Owner (FRBO.com) and conceive private bungalow and suburban condominium.
Join our studio advertisements, convenient online MLS, lakeside ads, and exclusive indexes mailing list for condo rentals Lee and Lee rental apartment.
Recognize, recognize, and ferret out vacation rental in Louisa Virginia, Louisa Virginia houses for rent, Louisa vacation homes for rent by owner, and bed and breakfast rentals Louisa Virginia.
Find out, light upon, and move vacation homes Fort Mitchell, Fort Mitchell United States short term rentals, and rental houses in Fort Mitchell.
Invent and identify Crozet United States holiday rentals and short term rentals Crozet United States.
Identify and look up vacation homes in York Virginia, condos for rent in York Virginia, and rental apartment in York Virginia.
Ascertain and uncover Raphine real estate rentals and rent house in Raphine United States.
Unoccupied decadent castle, spacious flat, suburban cabin, and well appointed home are proximate in the near-at-hand tract of Lee.
Contrive, identify, and identify homes for rent by owner, rental home in Vesuvius United States, and Vesuvius vacation rentals.
Conceive and detect Martinsville Virginia apartment rentals and Martinsville Virginia condos for rent.
|
|
