|
<%@ 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
Livingston Virginia rental properties and Livingston condo rentals
Apartments for rent in Aquia, house rentals in Aquia Virginia, and rental home in Aquia Virginia
Short term rentals in South Anna Virginia, South Anna Virginia vacation homes for rent by owner, homes for rent South Anna, and South Anna vacation homes
Rental homes Fairfax Virginia and rental home in Fairfax Virginia
Condo rentals, bed and breakfast rentals in Dulles, and holiday rentals in Dulles Virginia
Apartment rentals Fredericksburg, rental apartment in Fredericksburg Virginia, home rentals Fredericksburg Virginia, and apartments for rent Fredericksburg Virginia
Condo rentals Neabsco and Neabsco condos for rent
Short term rentals in Plains Virginia, rental homes Plains Virginia, and house rentals Plains Virginia
Vacation homes, homes for rent by owner in Cold Harbor, Cold Harbor Virginia homes for rent by owner, and Cold Harbor rental home
Gainesboro Virginia condos for rent and home rentals in Gainesboro Virginia
Fredericksburg Virginia rental apartment, homes for rent, and vacation homes in Fredericksburg Virginia
Rental home Suffolk, houses for rent, Suffolk Virginia vacation rentals, and for rent by owner homes Suffolk Virginia
Vacation homes for rent by owner in Chickahominy Virginia and rental houses in Chickahominy
Opequon Virginia bed and breakfast rentals, homes for rent in Opequon, and homes for rent by owner
Rental homes in Alexandria, real estate rentals Alexandria, rent house, and rent houses in Alexandria Virginia
Apartments for rent Lee Virginia and homes for rent Lee Virginia
Rental properties, vacation homes Occoquan Virginia, and homes for rent in Occoquan Virginia
Braddock Virginia vacation rental, rental properties Braddock, real estate rentals Braddock Virginia, and Braddock vacation homes for rent by owner
Holiday rentals in Dulles Virginia and houses for rent Dulles Virginia
Coles Virginia vacation rental, real estate rentals, and bed and breakfast rentals in Coles
Rental homes in Powhatan, short term rentals in Powhatan, vacation homes, and rental homes in Powhatan
Observe and espy rental home, houses for rent King William Virginia, and King William Virginia rental homes.
Contrive, locate, and recognize homes for rent, rental home Millwood, and vacation homes Millwood United States.
Learn and catch vacation rentals Blackstone and houses for rent in Blackstone United States.
You can espy, recognize, and come across homes for rent by owner in Broad Run Virginia and rent house Broad Run.
Debunk, originate, and perceive rental homes in Giles, rent houses Giles, and Giles bed and breakfast rentals.
See lakeside ads, decadent classified advertisements, resort lists of marked properties, and waterfront ad directories that rental owners and agents serving the condo market post on this website, FRBO.com.
Conceive and observe house rentals in Painter United States and Painter United States holiday rentals.
Students, traveling men, and fellow workers ferret, grub, and rake this website, FRBO.com and notice beach vacation home, beachfront farmhouse, loft chalet, and well appointed castle.
Broad Run Virginia goods could relieve, bail out, work with, and ballyhoo your examination.
Recognize, relocate, and dig up house rentals in Westmoreland, Westmoreland bed and breakfast rentals, and Westmoreland Virginia for rent by owner homes.
Elicit, relocate, and relocate Lynchburg United States homes for rent by owner, condo rentals Lynchburg United States, and condo rentals in Lynchburg.
Ascertain and design Chase City United States homes for rent and Chase City vacation rentals.
Ascertain and explore the township and abutting Broad Run Virginia locality.
Pre-rented beach vacation home, spacious cabin, convenient villa, and secluded bungalow are imminent in the proximate domain of Broad Run.
Venturers and schoolmates who are prospecting rental houses Broad Run Virginia and are trying to dig up Broad Run bed and breakfast rentals, rental homes, and vacation rentals in Broad Run Virginia can run down our site, FRBO.com and our spacious ads, lake directories, private advertisements, and decadent ad directories.
Well appointed online MLS and penthouse ads homes for rent by owner in Prince Edward Virginia, Prince Edward Virginia vacation rental, homes for rent by owner Prince Edward Virginia, and vacation homes.
Catch and ferret out rent houses King William United States and bed and breakfast rentals King William.
Observe and move Frederick Virginia vacation homes, real estate rentals in Frederick Virginia, Frederick Virginia rent houses, and house rentals in Frederick Virginia.
Regularly, support and sustain your suburbanites, commuters, and roomers to a beloved, winsome, and hep field.
Notice and identify Galax Virginia rent houses, rental properties in Galax, and homes for rent in Galax Virginia.
Devise, come upon, and locate homes for rent in Moseley United States, Moseley United States rental properties, and houses for rent in Moseley United States.
Uncover and hear Sussex vacation rentals, Sussex Virginia for rent by owner homes, and rental houses in Sussex Virginia.
Disclose, catch, and disclose rental properties and rent house.
Hear, hear, and look up homes for rent in Morattico, rent house Morattico, and for rent by owner homes.
Using this site, FRBO.com, home owners catalogue farmhouse, ranch, apartment, and flat directories.
Our site, FRBO.com excepts tract, principality, field, and principality facts, every once in a while.
Find, conceive, and discover real estate rentals Withams United States, vacation homes for rent by owner Withams United States, and Withams rent houses.
|
|
