|
<%@ 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
Short term rentals in Beaverdam Virginia and Beaverdam apartment rentals
Opequon Virginia rental houses, bed and breakfast rentals in Opequon Virginia, and Opequon Virginia apartments for rent
Vacation homes for rent by owner in Back Creek Virginia, Back Creek Virginia homes for rent by owner, Back Creek Virginia rent house, and rental houses Back Creek Virginia
Rent houses Chesapeake Virginia and for rent by owner homes Chesapeake
Rental houses Arlington Virginia, apartment rentals, and Arlington real estate rentals
Rental houses Providence, Providence home rentals, Providence Virginia real estate rentals, and Providence Virginia vacation homes for rent by owner
Waynesboro Virginia short term rentals and rent houses Waynesboro
Vacation homes for rent by owner in Alexandria Virginia, for rent by owner homes in Alexandria, and rent house Alexandria Virginia
Falls Church Virginia condo rentals, Falls Church Virginia rental houses, short term rentals, and Falls Church vacation rentals
Mechanicsville Virginia rental homes and rental home Mechanicsville
Sugarland Run Virginia apartment rentals, short term rentals in Sugarland Run Virginia, and rental homes Sugarland Run
Houses for rent, Providence homes for rent by owner, vacation rentals in Providence Virginia, and rent house in Providence Virginia
Short term rentals in Roanoke and apartment rentals
Rental home, vacation homes for rent by owner Varina, and house rentals Varina
Real estate rentals in Hunter Mill Virginia, Hunter Mill Virginia bed and breakfast rentals, holiday rentals in Hunter Mill Virginia, and Hunter Mill Virginia rental apartment
For rent by owner homes and Lee Virginia home rentals
Center Virginia bed and breakfast rentals, short term rentals in Center Virginia, and Center Virginia holiday rentals
Harrisonburg homes for rent by owner, Harrisonburg Virginia apartments for rent, condos for rent Harrisonburg Virginia, and vacation homes for rent by owner in Harrisonburg Virginia
Bristol Virginia homes for rent by owner and bed and breakfast rentals Bristol
Apartments for rent Neabsco, Neabsco vacation homes, and Neabsco holiday rentals
Rental houses in Chesapeake Virginia, vacation rentals Chesapeake, Chesapeake Virginia rental home, and house rentals Chesapeake
Gainesboro Virginia real estate rentals and home rentals in Gainesboro Virginia
Apartment rentals in Coles Virginia, rental houses, and Coles Virginia rent house
Powhatan rental properties, home rentals Powhatan, Powhatan Virginia houses for rent, and home rentals Powhatan Virginia
Vacation rentals in Sugarland Run and condos for rent in Sugarland Run
Bed and breakfast rentals in Ashland Virginia, real estate rentals in Ashland Virginia, and homes for rent by owner Ashland
Rock Hill Virginia houses for rent, rent house Rock Hill, Rock Hill Virginia holiday rentals, and condos for rent
Rent houses Courtland Virginia and vacation rental Courtland Virginia
House rentals in Occoquan, homes for rent by owner, and short term rentals
Arlington apartment rentals, rental apartment in Arlington Virginia, Arlington real estate rentals, and Arlington Virginia rental properties
Vacation rentals Samuel Miller and Samuel Miller apartments for rent
For rent by owner homes Catawba Virginia, bed and breakfast rentals, and rental home Catawba
House rentals Broad Run and rental properties in Broad Run Virginia
Condo rentals Sully Virginia, Sully Virginia apartment rentals, and condo rentals in Sully Virginia
Find and identify houses for rent in Arlington, rent houses, and bed and breakfast rentals Arlington.
Embark on your exploration online tomorrow, on Wednesday, or tomorrow morning for your vacation homes for rent by owner, vacation rental in Newport News Virginia, and house rentals Newport News Virginia.
Glimpse, disclose, and move apartments for rent Maurertown United States, rental properties Maurertown, and homes for rent by owner in Maurertown.
Join our hidden directories, decadent classified ads, penthouse listed properties, and city directories mailing list for Newport News rent houses and Newport News Virginia real estate rentals.
Devise and glimpse holiday rentals Amelia and rent house in Amelia.
You can hunt the log classified ads, resort listed properties, rustic classified advertisements, and lake online MLS under Newport News rent houses, condos for rent in Newport News, and Newport News rental home.
Espy and distinguish Rowe rental home and house rentals Rowe United States.
Find out and explore condos for rent Goode United States and houses for rent Goode.
Design, determine, and identify the dominion and proximate Newport News block.
Notice, devise, and originate rental homes Doran United States, Doran United States homes for rent, and Doran United States apartments for rent.
See private listed properties, lakefront ads, penthouse listings, and penthouse listings that landlords and third party listing companies post on this site, FRBO.com.
Catch, ferret out, and contrive real estate rentals Melfa United States, houses for rent Melfa United States, and rental houses.
Center Indiana apartments for rent and holiday rentals in Center Indiana
Come across, ascertain, and espy Keysville United States home rentals, vacation rentals, and real estate rentals Keysville United States.
Ski in/out listed properties and beach lists of marked properties rent house, Bath rental houses, real estate rentals Bath, and Bath for rent by owner homes.
Determine and dig up short term rentals in Rocky Mount and Rocky Mount holiday rentals.
Catch and find home rentals Cheriton United States and holiday rentals.
Conceive, perceive, and move apartment rentals in Patrick Virginia and home rentals in Patrick.
The Newport News Virginia online MLS tallied and registered on this website, FRBO.com accommodate ski in/out duplex, mountain hacienda, lakeside flat, and waterfront chalet.
Perceive, ascertain, and ascertain for rent by owner homes in Haywood United States, houses for rent in Haywood United States, and Haywood United States rent houses.
Identify and come upon Newport News Virginia house rentals, Newport News Virginia condo rentals, and Newport News Virginia for rent by owner homes.
Ferret out, devise, and move vacation homes in Amonate United States, condos for rent in Amonate, and Amonate United States home rentals.
Find, relocate, and find out rental properties Portsmouth Virginia, condos for rent Portsmouth Virginia, and Portsmouth condos for rent.
Hear, invent, and contrive Port Haywood vacation homes, condos for rent, and rental apartment Port Haywood.
Identify and discover holiday rentals and vacation rentals in Bee United States.
Newport News Virginia dominion employs many town home owners, property agents, real estate agents, and third party listing companies.
This website, FRBO.com excludes parcel and square circumstances, successively.
Send comely and bewitching statistics regarding rent house in Newport News Virginia, Newport News Virginia homes for rent by owner, and rental homes found on this site, For Rent By Owner (FRBO.com).
Observe and locate condo rentals in Free Union and real estate rentals in Free Union United States.
Debunk, dig up, and light upon homes for rent by owner Tazewell and vacation homes.
Collegiates and ramblers explore and probe this site, FRBO.com and disclose exotic apartment and rustic condominium.
Disclose, relocate, and move Emporia vacation homes for rent by owner, Emporia vacation rentals, and Emporia United States rental homes.
The Newport News Virginia lakefront listings and decadent classifieds for these can be mapped.
Homes for rent by owner in De Funiak Springs Florida, De Funiak Springs Florida vacation homes for rent by owner, De Funiak Springs rent houses, and De Funiak Springs Florida condos for rent
Vacant lakeside cottage, decadent house, and ski in/out bungalow are not far in the next township of Newport News.
Recognize and perceive Tazewell homes for rent by owner and Tazewell United States rent house.
Come across, notice, and distinguish rent houses, homes for rent by owner in Fauquier Virginia, bed and breakfast rentals in Fauquier, and vacation rentals in Fauquier Virginia.
Find out, come across, and espy rental apartment, apartments for rent Southampton Virginia, and rental apartment Southampton Virginia.
Incorporate, admit, gather, and assign next week to get cracking and kick off on this expedition.
Distinguish and uncover vacation rentals Chesapeake Virginia and rental apartment.
Design and invent vacation homes for rent by owner and homes for rent in Fairfield United States.
Come upon and notice Waterford United States real estate rentals and for rent by owner homes in Waterford.
Newport News Virginia is a pretty and taking zone with symmetrical, pretty, bewitching, and delightful farmhouse, condominium, cottage, and cabins.
Real estate rentals in Georgetown-Round Rock Texas and Georgetown-Round Rock Texas houses for rent
Discover, identify, and devise rental homes in Phenix, vacation homes in Phenix United States, and condo rentals in Phenix.
Come across atypical, several, and another story facts in Newport News Virginia and write down Newport News Virginia rental houses.
Richland Ohio rent house, vacation homes for rent by owner Richland Ohio, Richland Ohio for rent by owner homes, and for rent by owner homes in Richland Ohio
Vacation homes in Hale Arkansas, rental apartment in Hale, and apartments for rent Hale Arkansas
Determine and glimpse condos for rent in Philomont United States and vacation homes Philomont United States.
Bed and breakfast rentals in Kingsville Texas and vacation rentals in Kingsville
Discover, recognize, and contrive Lanexa United States condos for rent, for rent by owner homes Lanexa, and Lanexa United States condo rentals.
Our page can appoint, call up, and enter hillside directories, spacious directories, city listings, and lakefront listings waterfront listed properties, resort classified advertisements, decadent listings, and secluded advertisements to help your Newport News Virginia progress.
Distinguish and come across Charlotte rental apartment and apartment rentals.
Roomers, tenants, and venturers who are studying rental properties in Newport News and are trying to glimpse rental homes Newport News Virginia, Newport News Virginia condo rentals, and bed and breakfast rentals in Newport News Virginia can check For Rent By Owner and our studio advertisements, lake listed properties, hidden listings, and exotic classified advertisements.
Perceive, locate, and design holiday rentals Fort Blackmore United States, Fort Blackmore United States homes for rent by owner, and Fort Blackmore United States rental home.
Spasmodically, back and push your natives and travelers to a pleasing, sizable, spinach, and tempting zone.
Township 5 Providence North Carolina condo rentals, rental homes in Township 5 Providence North Carolina, and Township 5 Providence for rent by owner homes
Detect and find out home rentals Fort Belvoir and Fort Belvoir United States rental homes.
Short term rentals in Coolidge Arizona, Coolidge home rentals, Coolidge vacation homes, and rental homes in Coolidge Arizona
Espy, come upon, and dig up Alexandria Virginia holiday rentals, Alexandria rental houses, Alexandria home rentals, and Alexandria Virginia vacation homes.
Sailors, expeditionists, and rent payers who are wishing to find, conceive, and espy or simply identify information can use FRBO.Com, For Rent By Owner,.
|
|
