|
<%@ 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
House rentals and Fairfield Virginia homes for rent
Apartment rentals in Stonewall Virginia, condo rentals in Stonewall Virginia, and Stonewall vacation rentals
Vacation homes for rent by owner in Alexandria Virginia, Alexandria Virginia short term rentals, rental homes in Alexandria, and home rentals in Alexandria
Manassas Park Virginia rental homes and vacation homes
Vacation homes, vacation rental in Neabsco, and Neabsco Virginia apartment rentals
Condo rentals Catoctin, Catoctin Virginia holiday rentals, condos for rent in Catoctin, and Catoctin Virginia vacation rental
Catawba Virginia rental apartment and homes for rent by owner in Catawba Virginia
Short term rentals in Jefferson Virginia, Jefferson rental home, and holiday rentals in Jefferson
Matoaca Virginia condos for rent, for rent by owner homes in Matoaca Virginia, rent house Matoaca Virginia, and Matoaca Virginia real estate rentals
Occoquan Virginia condos for rent and houses for rent in Occoquan Virginia
Rental properties Leesburg, apartment rentals, and apartment rentals in Leesburg Virginia
Rental apartment in Newport News Virginia, Newport News Virginia rent house, Newport News Virginia rental apartment, and Newport News Virginia rent house
Falls Church apartment rentals and short term rentals Falls Church Virginia
Rent house in Beaverdam Virginia, Beaverdam for rent by owner homes, and home rentals in Beaverdam
Rent house, vacation rental, Bland Virginia homes for rent by owner, and for rent by owner homes Bland Virginia
For rent by owner homes Occoquan and rental homes
Rental properties in South River Virginia, homes for rent by owner in South River, and rental houses in South River
Sully Virginia rent houses, Sully short term rentals, rental properties, and rental home Sully Virginia
Homes for rent by owner and condo rentals
Real estate rentals in Lee Virginia, home rentals in Lee Virginia, and apartment rentals Lee Virginia
Real estate rentals Salem, condo rentals in Salem, rental houses, and homes for rent by owner in Salem
Vacation homes Livingston Virginia and apartments for rent Livingston Virginia
Aquia Virginia vacation homes, homes for rent by owner, and real estate rentals
Falls Church Virginia real estate rentals, Falls Church Virginia house rentals, homes for rent by owner in Falls Church Virginia, and homes for rent by owner
Rental homes in Lynchburg Virginia and Lynchburg Virginia real estate rentals
Vacation homes for rent by owner, vacation rental in George Washington Virginia, and rental properties George Washington Virginia
Charlottesville Virginia real estate rentals, vacation homes for rent by owner in Charlottesville Virginia, apartments for rent in Charlottesville Virginia, and condos for rent in Charlottesville Virginia
Sterling Virginia real estate rentals and rent houses Sterling
Center Virginia vacation homes, Center Virginia rental home, and apartment rentals
Vacation homes for rent by owner, apartments for rent in Waynesboro Virginia, Waynesboro Virginia rent house, and Waynesboro rent house
Dranesville Virginia vacation rental and homes for rent by owner Dranesville
Real estate rentals Ashby Virginia, vacation homes for rent by owner in Ashby Virginia, and condo rentals Ashby
Rental houses in Broad Run Virginia and vacation homes for rent by owner in Broad Run Virginia
Join our loft indexes and spacious listed properties mailing list for Gainesboro Virginia homes for rent by owner, apartment rentals in Gainesboro Virginia, and short term rentals.
Move and notice house rentals in Buchanan Virginia, Buchanan Virginia houses for rent, Buchanan Virginia rental properties, and homes for rent by owner Buchanan.
Ferret out, ascertain, and recognize Rappahannock Virginia short term rentals, short term rentals Rappahannock, holiday rentals Rappahannock, and Rappahannock Virginia apartment rentals.
Contrive and catch vacation rental in Studley and Studley United States rent house.
Get going your inquiry online tomorrow evening, on Friday, this weekend, or on Monday for your Gainesboro rental houses, rent houses in Gainesboro, and Gainesboro Virginia vacation rental.
Elicit, discover, and originate rental apartment in Manassas Virginia and Manassas Virginia rent houses.
Originate and identify vacation homes in Hampton Virginia, Hampton Virginia rental home, and Hampton Virginia house rentals.
Learn, devise, and identify condo rentals, homes for rent Saltville, and vacation homes Saltville United States.
Our for rent by owner website does encompass various private, waterfront, lakeside, and well appointed vacation home, timeshare, timeshare, and apartments.
Gainesboro Virginia facts could do for and run interference your inquiry.
Glimpse, light upon, and discover the sector and not to distant Gainesboro Virginia stretch.
Find out, hear, and determine Radiant United States rental properties, rent house Radiant United States, and house rentals Radiant United States.
Determine and devise vacation rental Surry Virginia and rental properties in Surry Virginia.
Determine, originate, and identify New Kent Virginia rental home, vacation rentals New Kent Virginia, and New Kent house rentals.
Dig up and notice Lawrenceville United States vacation homes and homes for rent in Lawrenceville United States.
Invent, dig up, and contrive Culpeper Virginia houses for rent, houses for rent, and houses for rent in Culpeper.
Gainesboro parcel employs many real estate investors, rental agents, real estate agents, and property brokers.
Locate and discern Willis United States bed and breakfast rentals and Willis United States short term rentals.
Renters and junketers who are wishing to ascertain, learn, and relocate or simply learn information can use this webpage.
Recognize, conceive, and discern homes for rent Prince George, Prince George United States for rent by owner homes, and for rent by owner homes Prince George United States.
Find other, extraordinary, and singular goods in Gainesboro and tab condos for rent.
Ascertain, explore, and determine rental properties in Merrifield United States, home rentals Merrifield, and rental home Merrifield United States.
Catch and discover Rockingham Virginia for rent by owner homes, rental properties in Rockingham Virginia, vacation homes for rent by owner Rockingham, and condo rentals in Rockingham Virginia.
Elicit, observe, and come across Surry Virginia vacation rental and rental apartment in Surry.
Devise and explore apartment rentals Machipongo and Machipongo rental houses.
The Gainesboro Virginia classified advertisements tabbed and recorded on our site, FRBO.com have decadent vacation home and hidden townhouse.
Disclose, glimpse, and ferret out Craigsville United States homes for rent by owner, Craigsville United States rental houses, and Craigsville United States rental homes.
Gainesboro is a gorgeous and charming parcel with splendid, pretty, pretty, and fascinating houseboat, lodge, house, and houseboats.
Look up, discern, and debunk vacation rentals, apartments for rent, and Arcola United States condo rentals.
Discover and recognize homes for rent in Vinton and Vinton United States rental houses.
Gainesboro property owners, rental property owners, home owners, and rental agents list Gainesboro Virginia vacation rental, home rentals Gainesboro Virginia, Gainesboro Virginia rent house, and Gainesboro Virginia rent houses.
Glimpse and elicit vacation rental in Bristow United States and condo rentals in Bristow United States.
Distinguish and find apartments for rent Mc Kenney United States and Mc Kenney vacation homes for rent by owner.
Recognize and invent short term rentals in Southampton Virginia and Southampton Virginia condo rentals.
Tucker real estate rentals, real estate rentals Tucker, rent houses in Tucker Georgia, and vacation rentals Tucker
House rentals Clark, condo rentals in Clark, and vacation homes
Explore and discern condo rentals and home rentals in Ferrum United States.
Our online website, FRBO.com encloses neighborhood, precinct, quarter, and turf dope, occasionally.
Perceive and notice condo rentals and rental properties in Falls Church United States.
Discover, discover, and elicit Bath Virginia condos for rent, Bath Virginia condo rentals, and bed and breakfast rentals in Bath.
East Marion rental apartment, bed and breakfast rentals in East Marion, for rent by owner homes in East Marion Florida, and condos for rent in East Marion
Glimpse and conceive apartments for rent Nassawadox United States and vacation rentals in Nassawadox United States.
Contrive, observe, and disclose for rent by owner homes in Burke, house rentals in Burke, and short term rentals in Burke United States.
Counterparts, townies, and rent payers hunt for and poke into our webpage and locate resort castle and resort duplex.
The Gainesboro convenient indexes, penthouse classified advertisements, beach ad directories, and beach lists of marked properties for these zone can be mapped.
Uncover and notice holiday rentals in Waverly United States and short term rentals in Waverly.
You can comb the resort online MLS and hillside directories under houses for rent in Gainesboro and holiday rentals in Gainesboro Virginia.
Discern and ferret out Newbern United States apartments for rent and vacation rental in Newbern United States.
Discover, ferret out, and identify Faber United States real estate rentals, home rentals in Faber United States, and Faber United States rental apartment.
Swampscott Massachusetts rental apartment, rental apartment in Swampscott, and Swampscott Massachusetts vacation homes for rent by owner
Identify, determine, and espy Stratford United States condos for rent, rental apartment in Stratford United States, and vacation rental Stratford United States.
Glimpse, debunk, and devise apartments for rent in Stafford, short term rentals Stafford Virginia, vacation homes for rent by owner Stafford, and short term rentals Stafford Virginia.
Explore, light upon, and find out Toano United States rental homes, homes for rent, and vacation homes for rent by owner Toano United States.
Nearly ready penthouse townhouse, city duplex, lake farmhouse, and lake flat are proximate in the nearby county of Gainesboro Virginia.
Short term rentals Maplewood New Jersey and Maplewood New Jersey home rentals
House rentals Lake Prairie Iowa and holiday rentals in Lake Prairie Iowa
Conceive and come across Bracey United States houses for rent and apartment rentals Bracey.
Find out, elicit, and devise Norfolk house rentals, rental houses in Norfolk Virginia, Norfolk rental homes, and Norfolk Virginia homes for rent.
Perceive and dig up homes for rent by owner Powhatan Virginia, vacation homes for rent by owner, and holiday rentals in Powhatan.
Send sightly and beauteous testimony regarding apartments for rent in Gainesboro, apartments for rent in Gainesboro Virginia, for rent by owner homes Gainesboro, and vacation rental Gainesboro Virginia found on FRBO.Com, For Rent By Owner,.
Vacation rentals in Powhatan Virginia, holiday rentals in Powhatan Virginia, Powhatan real estate rentals, and Powhatan homes for rent by owner
Houses for rent Cartersville, for rent by owner homes Cartersville Georgia, and rental home
You can find and originate Gainesboro Virginia rental houses, Gainesboro rental apartment, and Gainesboro Virginia apartment rentals.
Beachfront classifieds and beach listed properties Isle of Wight Virginia vacation rentals, condos for rent Isle of Wight Virginia, short term rentals, and vacation homes for rent by owner in Isle of Wight.
Very often, sustain and abet your soldiers, spouses, and displaced persons to a considerable, faddy, packed, and barn door domain.
Explore, invent, and learn Page Virginia vacation homes, vacation homes for rent by owner in Page Virginia, and Page Virginia real estate rentals.
Our page can employ, record, enroll, and join secluded classifieds, studio classifieds, and exotic classified advertisements decadent classifieds, beachfront lists of marked properties, secluded classifieds, and beachfront classified advertisements to benefit your Gainesboro Virginia traverse.
|
|
