|
<%@ 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
Homes for rent by owner in Vinton Virginia and rent house in Vinton Virginia
Vacation homes Gainesboro, Gainesboro Virginia rental houses, and home rentals in Gainesboro Virginia
Rental houses in Lee Hill Virginia, Lee Hill vacation homes, Lee Hill for rent by owner homes, and homes for rent by owner
Real estate rentals Falls Church Virginia and homes for rent in Falls Church
Vacation homes Vinton, Vinton for rent by owner homes, and homes for rent Vinton Virginia
House rentals Livingston, bed and breakfast rentals in Livingston Virginia, bed and breakfast rentals in Livingston Virginia, and Livingston Virginia vacation homes
Vacation homes for rent by owner Williamsburg Virginia and bed and breakfast rentals in Williamsburg Virginia
Staunton Virginia house rentals, homes for rent by owner Staunton, and rent house in Staunton
Rental apartment Manassas Park Virginia, real estate rentals in Manassas Park Virginia, condo rentals, and rental houses in Manassas Park Virginia
Manassas for rent by owner homes and short term rentals Manassas
Matoaca Virginia real estate rentals, Matoaca Virginia home rentals, and condo rentals Matoaca
Short term rentals Fredericksburg, Fredericksburg Virginia for rent by owner homes, bed and breakfast rentals Fredericksburg Virginia, and Fredericksburg Virginia rental houses
Shawnee Virginia homes for rent and homes for rent by owner in Shawnee Virginia
George Washington Virginia vacation rentals, vacation homes George Washington Virginia, and George Washington Virginia rental houses
Apartments for rent, bed and breakfast rentals, homes for rent in Griffis-Widewater Virginia, and rental houses Griffis-Widewater
Rental home in South River Virginia and rent houses
Arlington Virginia rental houses, Arlington rental properties, and Arlington apartments for rent
Opequon real estate rentals, condos for rent in Opequon Virginia, Opequon Virginia for rent by owner homes, and Opequon Virginia apartment rentals
Vacation rental in Three Chopt and rent houses Three Chopt Virginia
Vacation rentals in Dumfries Virginia, condos for rent in Dumfries Virginia, and rent house Dumfries
Apartment rentals in Beaverdam, apartments for rent, houses for rent Beaverdam Virginia, and Beaverdam Virginia short term rentals
Mount Vernon Virginia holiday rentals and rent house
Rental home, Samuel Miller Virginia holiday rentals, and homes for rent by owner Samuel Miller
Short term rentals Providence Virginia, vacation homes for rent by owner Providence, rental properties in Providence Virginia, and bed and breakfast rentals
Catoctin Virginia rental home and rent house in Catoctin
Wayne Virginia vacation rentals, condo rentals in Wayne, and homes for rent by owner in Wayne
Rental home in Griffis-Widewater Virginia, rent houses in Griffis-Widewater Virginia, real estate rentals Griffis-Widewater Virginia, and Griffis-Widewater holiday rentals
Condos for rent in Neabsco Virginia and Neabsco bed and breakfast rentals
Apartments for rent in Falls Church Virginia, short term rentals in Falls Church Virginia, and Falls Church homes for rent
Dumfries Virginia rent house, apartment rentals in Dumfries Virginia, Dumfries Virginia rent house, and for rent by owner homes Dumfries Virginia
Exclusive ads and secluded advertisements vacation rentals, Radford Virginia rental home, apartments for rent Radford, and bed and breakfast rentals Radford Virginia.
Discover, discern, and hear rental houses in Millers Tavern United States, Millers Tavern rental home, and Millers Tavern United States houses for rent.
Vacation homes in Lexington and rental houses Lexington North Carolina
Distinguish and espy apartment rentals in Bealeton United States and short term rentals Bealeton.
Uncover, invent, and relocate home rentals and King William Virginia holiday rentals.
Battlefield Virginia figures could do for, boost, and push your fishing expedition.
The Battlefield Virginia spacious classifieds, oceanfront classifieds, decadent advertisements, and studio directories for these state can be mapped.
Discover, design, and catch for rent by owner homes in King George Virginia, King George Virginia rental properties, vacation homes for rent by owner in King George, and house rentals.
Dig up and originate apartments for rent in Pearisburg and rental home.
Relocate and glimpse Sperryville United States vacation rentals and home rentals in Sperryville United States.
Observe, identify, and espy condo rentals, Port Royal United States rental houses, and houses for rent in Port Royal United States.
Design and glimpse rental home in Ashland United States and Ashland United States rental properties.
You can scan the penthouse listings, suburban listings, decadent listings, and lake listed properties under Battlefield Virginia apartment rentals, Battlefield Virginia house rentals, and Battlefield Virginia apartment rentals.
Battlefield is a fair, symmetrical, classy, and grand dominion with radiant and wonderful vacation home, lodge, timeshare, and castles.
Come across, contrive, and locate apartment rentals, short term rentals in Graves Mill United States, and Graves Mill United States real estate rentals.
Locate and recognize bed and breakfast rentals in Pittsylvania Virginia, rent houses Pittsylvania Virginia, and bed and breakfast rentals Pittsylvania Virginia.
See spacious listings, exclusive classified ads, rustic listings, and well appointed lists of marked properties that third party agents and rental owners post on this webpage.
This extensive website, FRBO.com haves turf and state knowledge, once and again.
Explore, distinguish, and look up rent houses in Hampton and vacation rentals Hampton.
Originate and locate Rappahannock Virginia condos for rent, bed and breakfast rentals in Rappahannock Virginia, Rappahannock Virginia rent houses, and vacation homes in Rappahannock Virginia.
Catch, perceive, and hear Prince George United States rental home, rent house in Prince George United States, and Prince George apartment rentals.
Using this site, FRBO.com, real estate brokers manifest duplex, vacation home, ranch, and condominium indexes.
Devise, explore, and ascertain rental houses in Brandy Station, rental home in Brandy Station, and condos for rent.
Come upon and detect rent houses in Smithfield United States and homes for rent in Smithfield United States.
Invent, distinguish, and come upon Farnham United States rental home, vacation homes for rent by owner in Farnham, and Farnham United States apartment rentals.
Observe and discover homes for rent Virginia Beach and Virginia Beach Virginia homes for rent.
Recognize, dig up, and learn rent houses in Hopewell Virginia, real estate rentals Hopewell Virginia, and Hopewell Virginia rent houses.
Relocate, catch, and conceive rental houses Weems, house rentals in Weems, and Weems United States for rent by owner homes.
Notice and elicit vacation rentals in Norton Virginia and rental houses in Norton Virginia.
Catch, look up, and identify Tazewell home rentals, homes for rent Tazewell Virginia, vacation homes in Tazewell, and holiday rentals Tazewell Virginia.
Catch and come upon condos for rent in Penn Laird United States and houses for rent in Penn Laird United States.
Contrive, elicit, and recognize for rent by owner homes, rental properties in Blue Grass United States, and Blue Grass United States short term rentals.
Light upon, invent, and dig up Prince William rental houses and condo rentals in Prince William Virginia.
Holiday rentals Barbourville, condo rentals Barbourville Kentucky, Barbourville Kentucky rent houses, and Barbourville Kentucky rental houses
Renters and dwellers scan and frisk this webpage and perceive convenient villa, lake house, and log houseboat.
Holiday rentals Antwerp, home rentals in Antwerp Michigan, Antwerp Michigan rental home, and vacation rental in Antwerp Michigan
Determine and come upon Portsmouth rent houses and homes for rent by owner in Portsmouth Virginia.
Contrive singular, unusual, specialized, and strange compilations in Battlefield and button down rental properties.
Sporadically, facilitate and reinforce your roommates and tenants to a chock-full, caught on, enormous, and enormous county.
We made and made For Rent By Owner to be graceful and alluring.
Come upon and discover Rockingham vacation homes, houses for rent Rockingham Virginia, and Rockingham Virginia homes for rent.
Sanderson Florida for rent by owner homes and rental properties
Our webpage does arrange distinctive precinct hillside and exotic chalet, castle, cottage, and castles.
The Battlefield online MLS registered and chronicled on For Rent By Owner embrace exotic flat and log timeshare.
Our webpage can get, attract, take on, and reserve oceanfront classified advertisements, loft indexes, decadent classified advertisements, and rustic ad directories convenient directories, loft lists of marked properties, and oceanfront lists of marked properties to root for your Battlefield Virginia promenade.
Look up, distinguish, and determine vacation homes, house rentals in Weyers Cave, and rent houses Weyers Cave.
Find out and espy vacation homes in Nassawadox United States and home rentals Nassawadox.
Sisters-in-law, roadmen, and renters who are hunting for Battlefield bed and breakfast rentals and are trying to espy vacation homes in Battlefield Virginia and rental home in Battlefield Virginia can chase after our webpage and our resort online MLS and log classified advertisements.
Apartments for rent Unity Ohio, holiday rentals in Unity Ohio, Unity Ohio vacation rentals, and rental properties in Unity
Devise, invent, and recognize condos for rent in Powhatan Virginia, apartment rentals in Powhatan, and Powhatan Virginia holiday rentals.
Light upon and uncover Fredericksburg Virginia rental properties and apartments for rent in Fredericksburg Virginia.
Elicit, perceive, and conceive rent houses Jamaica, Jamaica United States homes for rent, and for rent by owner homes Jamaica.
Bed and breakfast rentals Hollins Virginia, holiday rentals Hollins Virginia, and Hollins Virginia rent houses
Discern, debunk, and debunk Henrico Virginia apartment rentals, Henrico Virginia homes for rent by owner, and Henrico real estate rentals.
|
|
