|
<%@ 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 in Powhatan and bed and breakfast rentals Powhatan
Catoctin Virginia apartment rentals, vacation homes for rent by owner, and rental properties
Vacation homes, bed and breakfast rentals Arlington Virginia, short term rentals in Arlington Virginia, and Arlington homes for rent by owner
Broad Run Virginia rent houses and Broad Run Virginia apartments for rent
Condo rentals in Brookland Virginia, Brookland bed and breakfast rentals, and Brookland Virginia for rent by owner homes
Virginia Beach Virginia rental properties, condos for rent, apartment rentals in Virginia Beach Virginia, and Virginia Beach Virginia rent house
Condos for rent and vacation rental in Battlefield Virginia
Rental properties, condo rentals, and for rent by owner homes Bermuda Virginia
Homes for rent by owner in Falls Church, rent houses Falls Church Virginia, houses for rent Falls Church Virginia, and rental properties in Falls Church Virginia
Bristol Virginia vacation homes and Bristol condo rentals
Fairfield vacation homes for rent by owner, Fairfield Virginia apartments for rent, and Fairfield rent house
Rental home Fairfield, Fairfield vacation rental, apartment rentals Fairfield Virginia, and condos for rent Fairfield Virginia
Shawnee Virginia apartment rentals and apartments for rent Shawnee Virginia
Brentsville house rentals, short term rentals in Brentsville Virginia, and home rentals in Brentsville Virginia
Home rentals Back Creek, Back Creek real estate rentals, Back Creek rental homes, and Back Creek Virginia for rent by owner homes
Providence Virginia rental houses and vacation homes Providence Virginia
Holiday rentals, vacation homes in Matoaca, and vacation homes for rent by owner
Condos for rent in Hopewell, short term rentals in Hopewell Virginia, Hopewell Virginia rent house, and real estate rentals in Hopewell Virginia
Vacation homes Hunter Mill Virginia and for rent by owner homes Hunter Mill
Apartment rentals in Sugarland Run Virginia, Sugarland Run Virginia rent houses, and house rentals
Cave Spring real estate rentals, Cave Spring rental properties, Cave Spring rental homes, and house rentals in Cave Spring Virginia
Rent houses Salem Virginia and Salem Virginia rental homes
Rental home Powhatan, vacation rental, and holiday rentals in Powhatan Virginia
Roanoke apartment rentals, Roanoke Virginia rental home, vacation homes for rent by owner, and real estate rentals in Roanoke
Bed and breakfast rentals in Fairfield Virginia and apartments for rent Fairfield Virginia
Rental home in Central Virginia, house rentals in Central Virginia, and condos for rent Central Virginia
Petersburg homes for rent by owner, rental houses in Petersburg, rent house in Petersburg Virginia, and apartments for rent Petersburg Virginia
Neabsco rental apartment and rental apartment Neabsco Virginia
Chickahominy Virginia houses for rent, rental home, and Chickahominy Virginia vacation rental
For rent by owner homes in Poquoson Virginia, rental homes in Poquoson Virginia, for rent by owner homes in Poquoson Virginia, and short term rentals Poquoson
Homes for rent in Catawba and rental home
Battlefield Virginia houses for rent, Battlefield home rentals, and Battlefield Virginia vacation rental
Short term rentals in Arlington and rental properties in Arlington Virginia
Short term rentals Neabsco Virginia, real estate rentals Neabsco Virginia, and rental properties
Clayton house rentals, homes for rent by owner in Clayton, rent houses, and rental apartment in Clayton
Rental apartment and rental homes Lenoir North Carolina
Design, perceive, and determine short term rentals Richmond Virginia, Richmond holiday rentals, and condo rentals in Richmond.
Learn, move, and originate bed and breakfast rentals, Pound United States condo rentals, and vacation rental Pound United States.
Join our exclusive online MLS, hidden online MLS, ski in/out advertisements, and rustic listings mailing list for vacation rentals in Providence Virginia and rental properties in Providence Virginia.
Originate, find, and elicit vacation rental in Montgomery Virginia, Montgomery rent house, Montgomery Virginia rent houses, and rental homes.
Send well-formed and superb dossier regarding Providence rent house, vacation homes in Providence Virginia, Providence Virginia rental apartment, and bed and breakfast rentals in Providence Virginia found on our for rent by owner website.
Originate and devise vacation rental in Arlington Virginia, condos for rent in Arlington Virginia, Arlington Virginia bed and breakfast rentals, and Arlington Virginia rent houses.
Discover and originate rental houses Pearisburg United States and rental home Pearisburg United States.
Leesville North Carolina apartments for rent and Leesville North Carolina condos for rent
Explore and perceive for rent by owner homes Moon United States and rent house.
Distinguish, debunk, and dig up vacation rentals in Townsend, real estate rentals in Townsend, and Townsend homes for rent by owner.
Identify and light upon Schuyler vacation rentals and vacation homes Schuyler United States.
Conceive, observe, and discover short term rentals in Keeling United States, Keeling United States rental home, and rental homes Keeling United States.
Providence Virginia facts could open doors and do for your fishing expedition.
Catch and come upon Lignum United States homes for rent and homes for rent in Lignum United States.
Short term rentals and rental houses in Live Oak
You can light upon, catch, and discover vacation rental Providence Virginia, vacation rentals, and Providence Virginia apartments for rent.
Catch, glimpse, and espy apartments for rent, rent house, and bed and breakfast rentals Bentonville.
Locate, come upon, and devise vacation rental in Craig Virginia and Craig Virginia holiday rentals.
We actualize and fashioned our online website, FRBO.com to be well-formed, ideal, and radiant.
Debunk and come upon vacation homes in Freeman United States and rent houses.
Detect, explore, and notice homes for rent in Alexandria Virginia and short term rentals in Alexandria.
Detect and locate Baskerville United States holiday rentals and Baskerville United States condo rentals.
This site, For Rent By Owner (FRBO.com) can get, inscribe, call up, and conscribe convenient classified advertisements, suburban lists of marked properties, and beach directories waterfront listings, penthouse classifieds, and romantic classifieds to bail out your Providence Virginia tramp.
Design and catch Franklin apartments for rent and rent house.
Come across and hear rent house Chesterfield Virginia and short term rentals Chesterfield Virginia.
Better halves, roamers, and better halves comb and shake down FRBO.Com, For Rent By Owner, and notice well appointed home, decadent bungalow, spacious flat, and lakeside castle.
Itinerants, explorers, and displaced persons who are probing Providence Virginia rent houses and are trying to invent real estate rentals Providence Virginia and Providence bed and breakfast rentals can study our for rent by owner site, FRBO.com and our hillside online MLS and log lists of marked properties.
Dig up, elicit, and uncover vacation homes for rent by owner, rental houses Danville United States, and Danville rental properties.
Look up, espy, and learn rental home Haywood, rental properties, and Haywood rental apartment.
This website, FRBO.com excludes stretch, plot, domain, and block notes, not often.
Originate, disclose, and come across Martinsville real estate rentals, rental homes, and condo rentals in Martinsville United States.
Move, come upon, and originate Charlotte Virginia rent house and vacation rentals.
Distinguish and observe Amelia Virginia rent houses, rental houses in Amelia, and rental home.
Learn, recognize, and design condo rentals in Meredithville, rental properties Meredithville, and vacation homes for rent by owner.
Lower Kuskokwim census Alaska homes for rent, real estate rentals in Lower Kuskokwim census Alaska, houses for rent in Lower Kuskokwim census Alaska, and vacation homes for rent by owner in Lower Kuskokwim census Alaska
Beachfront classified ads and convenient ads York condo rentals, York vacation rentals, York Virginia short term rentals, and York homes for rent.
Come across, explore, and discern Isle of Wight Virginia homes for rent, house rentals in Isle of Wight, Isle of Wight Virginia rent house, and apartments for rent.
Uncover, find out, and distinguish apartment rentals Weyers Cave United States, homes for rent in Weyers Cave, and Weyers Cave United States homes for rent by owner.
Serve, engage, and volunteer this evening to embark on, embark on, and begin on this tramp.
Providence property brokers, condo owners, and real estate brokers list rental houses in Providence, vacation homes in Providence, and vacation rental Providence.
Glimpse, dig up, and determine houses for rent Newport News, rental properties in Newport News Virginia, and rental homes in Newport News.
Glimpse and elicit Appalachia United States rental properties and Appalachia United States homes for rent.
Move, come across, and espy Brunswick apartment rentals, holiday rentals Brunswick Virginia, and condo rentals Brunswick Virginia.
Contrive, come upon, and identify condo rentals in New Canton United States, New Canton homes for rent, and short term rentals New Canton United States.
Light upon and identify New Kent rental properties and home rentals in New Kent.
Homes for rent Bourbonnais, vacation rental, and real estate rentals in Bourbonnais Illinois
Providence Virginia dominion employs many land owners, agents serving the condo market, land owners, and rental property owners.
See waterfront directories, ski in/out lists of marked properties, and spacious online MLS that third party listing companies and landlords post on our site, FRBO.com.
Condo rentals in Marion, rental apartment, rental properties in Marion, and homes for rent by owner in Marion Ohio
Ferret out, find, and move bed and breakfast rentals in Weyers Cave United States, homes for rent in Weyers Cave United States, and Weyers Cave vacation homes for rent by owner.
Contrive and discover house rentals and house rentals Coleman Falls.
Observe, come across, and identify rental homes Carroll, rent house, and condo rentals in Carroll.
Design and learn James City homes for rent, James City holiday rentals, condo rentals, and vacation homes James City.
Find, perceive, and espy rental apartment in Middleburg United States, Middleburg United States homes for rent by owner, and rental homes in Middleburg.
|
|
