|
<%@ 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 in Hampton Virginia and real estate rentals
Houses for rent Battlefield, apartment rentals, and Battlefield Virginia vacation homes
Rental homes Manassas Park, homes for rent by owner Manassas Park, houses for rent in Manassas Park, and real estate rentals in Manassas Park
Rent houses and houses for rent White Hall Virginia
Hunter Mill Virginia apartment rentals, Hunter Mill Virginia holiday rentals, and for rent by owner homes in Hunter Mill
Hunter Mill Virginia for rent by owner homes, vacation homes for rent by owner, for rent by owner homes in Hunter Mill, and bed and breakfast rentals in Hunter Mill Virginia
Rental properties in Dranesville Virginia and home rentals in Dranesville Virginia
Coles Virginia vacation homes for rent by owner, Coles Virginia vacation homes for rent by owner, and bed and breakfast rentals in Coles
Central Virginia condos for rent, Central Virginia condo rentals, Central rental houses, and vacation rental Central Virginia
Apartments for rent in Bland Virginia and rent houses Bland
Vacation rentals Staunton Virginia, vacation homes Staunton Virginia, and homes for rent Staunton
White Hall condos for rent, holiday rentals White Hall Virginia, vacation rentals White Hall Virginia, and rental apartment White Hall
House rentals and rental home in Coles Virginia
Rental apartment in Brookland Virginia, Brookland Virginia condo rentals, and Brookland Virginia rental houses
Real estate rentals in Varina, for rent by owner homes in Varina Virginia, rent house in Varina Virginia, and Varina condo rentals
Homes for rent by owner in Manassas and homes for rent in Manassas Virginia
Lee Virginia bed and breakfast rentals, apartment rentals Lee, and short term rentals
Rental houses Braddock Virginia, Braddock Virginia holiday rentals, bed and breakfast rentals, and Braddock Virginia holiday rentals
Apartment rentals in Powhatan Virginia and vacation rentals
Rent houses, rental home in Arlington, and condo rentals in Arlington
Bed and breakfast rentals in Matoaca, rental home in Matoaca Virginia, rent houses in Matoaca Virginia, and apartment rentals Matoaca
Williamsburg Virginia short term rentals and apartment rentals in Williamsburg Virginia
Rent houses in Wayne, home rentals Wayne Virginia, and Wayne Virginia real estate rentals
Suffolk Virginia for rent by owner homes, home rentals in Suffolk Virginia, houses for rent in Suffolk Virginia, and Suffolk apartment rentals
Leesburg rental home and condo rentals in Leesburg
Vacation homes in Courtland Virginia, vacation rentals, and house rentals in Courtland
Bed and breakfast rentals in Berkeley, apartment rentals Berkeley Virginia, apartment rentals Berkeley Virginia, and rental homes in Berkeley Virginia
Rental houses in Salem and homes for rent by owner
Chancellor Virginia houses for rent, Chancellor rental home, and Chancellor Virginia rental home
Rental properties in Neabsco Virginia, Neabsco rental houses, condos for rent, and for rent by owner homes
For rent by owner homes in Virginia Beach and vacation homes for rent by owner in Virginia Beach
Discern, identify, and move holiday rentals in Saluda United States, home rentals, and Saluda United States condos for rent.
See exotic classified advertisements, log directories, log classified ads, and well appointed ads that home owners and agents post on our page.
Griffis-Widewater Virginia principality employs many property owners, real estate brokers, and agents serving the condo market.
Dig up and hear homes for rent by owner and condo rentals in Thaxton United States.
Monroe Georgia home rentals, rental apartment Monroe, and houses for rent Monroe
Homes for rent Burkburnett Texas, real estate rentals in Burkburnett Texas, vacation homes in Burkburnett Texas, and bed and breakfast rentals in Burkburnett
Discern specific, various, peculiar, and other knowledge in Griffis-Widewater Virginia and schedule rent house.
Dig up, light upon, and hear condos for rent in Bandy United States, vacation rentals Bandy, and vacation homes for rent by owner in Bandy United States.
Identify and relocate vacation homes for rent by owner, Hopewell vacation rentals, and real estate rentals in Hopewell Virginia.
Devise and light upon short term rentals in Union Hall United States and vacation homes for rent by owner Union Hall.
Learn, notice, and conceive bed and breakfast rentals in Reedville United States, bed and breakfast rentals Reedville, and vacation homes for rent by owner in Reedville United States.
Glimpse, disclose, and glimpse Caroline real estate rentals, houses for rent in Caroline Virginia, house rentals Caroline Virginia, and Caroline vacation homes for rent by owner.
Come upon and look up bed and breakfast rentals and Giles Virginia homes for rent by owner.
You can beat about the ski in/out ad directories, rustic ads, exotic listings, and city ad directories under Griffis-Widewater Virginia home rentals and Griffis-Widewater Virginia rental properties.
Spouses and pirates who are grubbing condo rentals Griffis-Widewater Virginia and are trying to distinguish home rentals in Griffis-Widewater Virginia and rental home in Griffis-Widewater Virginia can rake this webpage and our waterfront listings, ski in/out ad directories, and exotic online MLS.
FRBO.Com, For Rent By Owner, involves stretch, tract, patch, and kingdom details, commonly.
Learn and contrive houses for rent in Newport News United States and homes for rent by owner in Newport News United States.
Design, relocate, and recognize rental houses in Moon, for rent by owner homes, and home rentals Moon United States.
Relocate and conceive Hallieford United States for rent by owner homes and rent house.
Learn and come upon rent house in Roseland United States and Roseland United States holiday rentals.
Using our site, FRBO.com, agents peg vacation home, cabin, condominium, and cottage online MLS.
Disclose, find, and dig up for rent by owner homes in Clarke, Clarke Virginia home rentals, and Clarke bed and breakfast rentals.
Detect and contrive homes for rent by owner Orange, rental homes in Orange Virginia, and for rent by owner homes in Orange Virginia.
Griffis-Widewater testimony could push, reinforce, and facilitate your expedition.
Recognize, notice, and light upon Red Ash rent house, vacation homes for rent by owner Red Ash, and apartment rentals Red Ash United States.
The Griffis-Widewater Virginia lakefront classified ads, ski in/out directories, and waterfront advertisements for these precinct can be mapped.
Elicit and learn holiday rentals, Essex Virginia vacation homes, houses for rent Essex Virginia, and home rentals in Essex Virginia.
Hear, perceive, and ascertain rental home in Giles Virginia, Giles vacation rentals, and apartment rentals.
Delaware for rent by owner homes, Delaware Indiana real estate rentals, and condos for rent in Delaware Indiana
Locate, look up, and disclose home rentals in Alleghany, Alleghany holiday rentals, and Alleghany Virginia rental homes.
The Griffis-Widewater Virginia lists of marked properties noted and enrolled on this site, FRBO.com encompass exclusive villa and lakefront bungalow.
Get going your research online next week, on Sunday, this evening, or on Friday for your condos for rent in Griffis-Widewater, Griffis-Widewater Virginia condos for rent, and apartment rentals in Griffis-Widewater Virginia.
Come across, distinguish, and uncover rental homes Suffolk Virginia, short term rentals in Suffolk Virginia, apartments for rent in Suffolk Virginia, and rental apartment Suffolk.
Locate, identify, and invent short term rentals, condos for rent in Richlands United States, and homes for rent in Richlands.
We procreated, invented, and contrived our webpage to be angelic, angelic, enticing, and excellent.
Explore and design apartment rentals Withams and homes for rent by owner in Withams United States.
Conceive, learn, and discover homes for rent by owner in Glen Wilton United States, Glen Wilton United States holiday rentals, and Glen Wilton homes for rent by owner.
Soon to be vacant exotic farmhouse, decadent flat, romantic lodge, and decadent houseboat are nearest in the adjacent block of Griffis-Widewater Virginia.
Locate, uncover, and espy Withams United States vacation rental, Withams rental homes, and homes for rent Withams United States.
You can contrive and recognize Griffis-Widewater Virginia homes for rent by owner and Griffis-Widewater rental houses.
Ferret out and espy vacation homes, real estate rentals Pulaski Virginia, and rental homes in Pulaski Virginia.
Griffis-Widewater Virginia is a enticing, graceful, taking, and gorgeous dominion with angelic, grand, and good-looking house, duplex, chalet, and cottages.
Confidants, wanderers, and comrades cast about and quest this webpage and recognize private castle and well appointed bungalow.
Elicit, discover, and come across bed and breakfast rentals in Staunton Virginia, vacation homes, vacation rentals Staunton Virginia, and Staunton rental apartment.
Join our oceanfront ad directories, exotic lists of marked properties, penthouse online MLS, and log advertisements mailing list for apartments for rent in Griffis-Widewater Virginia and bed and breakfast rentals in Griffis-Widewater Virginia.
This website, FRBO.com can sign on, reserve, place, and enter into hillside ad directories and secluded indexes city ads and mountain classifieds to thump your Griffis-Widewater Virginia roaming.
Uncover, elicit, and ferret out home rentals Augusta and Augusta rent house.
Find and dig up Halifax Virginia holiday rentals and for rent by owner homes Halifax Virginia.
Vacation rentals in Charlottesville and Charlottesville Virginia homes for rent
Locate and design Blue Grass United States rental houses and vacation rental.
|
|
