|
<%@ 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
Rio Virginia apartment rentals and rental houses Rio Virginia
Woodbridge Virginia condo rentals, real estate rentals, and for rent by owner homes Woodbridge Virginia
Apartments for rent in Hollins Virginia, condos for rent in Hollins, Hollins Virginia holiday rentals, and Hollins Virginia short term rentals
Houses for rent in Dumfries Virginia and rent houses in Dumfries Virginia
House rentals Rivanna Virginia, homes for rent in Rivanna Virginia, and apartments for rent in Rivanna
Rental houses in Springfield Virginia, condos for rent in Springfield, Springfield Virginia bed and breakfast rentals, and Springfield Virginia rental home
Powhatan Virginia rent houses and bed and breakfast rentals Powhatan Virginia
Martinsville condos for rent, homes for rent by owner in Martinsville Virginia, and Martinsville house rentals
Wayne Virginia holiday rentals, rent houses Wayne Virginia, Wayne Virginia rental apartment, and Wayne Virginia homes for rent
Harrisonburg holiday rentals and homes for rent Harrisonburg Virginia
Portsmouth bed and breakfast rentals, condo rentals Portsmouth Virginia, and Portsmouth homes for rent
Rental properties Alexandria, rental properties Alexandria, Alexandria Virginia bed and breakfast rentals, and Alexandria houses for rent
Chickahominy Virginia rental houses and condo rentals in Chickahominy
Home rentals in Mercer Virginia, apartments for rent Mercer, and Mercer Virginia vacation homes for rent by owner
Central Virginia houses for rent, rent house in Central, houses for rent, and Central apartment rentals
Rock Hill rent house and rental properties in Rock Hill
Center vacation homes for rent by owner, Center Virginia condo rentals, and bed and breakfast rentals
Bed and breakfast rentals Lynchburg, Lynchburg vacation rental, apartment rentals Lynchburg, and holiday rentals Lynchburg
Holiday rentals Portsmouth and rental homes in Portsmouth Virginia
Varina Virginia home rentals, rental properties in Varina Virginia, and vacation homes
House rentals Poquoson, Poquoson rent house, rental apartment in Poquoson Virginia, and homes for rent by owner in Poquoson
Houses for rent Coles Virginia and Coles short term rentals
Uncover and hear homes for rent, home rentals Montgomery Virginia, and vacation homes Montgomery.
Lead off your inquiry online next week, next weekend, tomorrow evening, or now for your rental properties in Chancellor and rent house in Chancellor.
Explore and detect Floyd Virginia rental apartment and for rent by owner homes.
Espy, uncover, and look up rental properties and rental properties in Colonial Heights Virginia.
This site, FRBO.com does take in distinct plot ski in/out, studio, city, and hillside castle, condominium, townhouse, and lodges.
Contrive, identify, and espy real estate rentals in Evergreen, rent house Evergreen, and Evergreen for rent by owner homes.
Using FRBO.com, condo owners enter cottage and home ad directories.
Dig up, find, and distinguish short term rentals in Harrisonburg Virginia, house rentals in Harrisonburg Virginia, and rental home in Harrisonburg Virginia.
The Chancellor Virginia ad directories itemized and run down on this extensive website, FRBO.com encompass beachfront vacation home, beach ranch, studio townhouse, and rustic lodge.
Chancellor Virginia plot employs many real estate investors, third party agents, and agents.
Glimpse, debunk, and find out vacation homes in Stanley United States, rental home Stanley, and homes for rent by owner in Stanley United States.
Uncover, perceive, and design Studley United States condo rentals, rental properties, and vacation homes for rent by owner Studley.
Find out and identify Roanoke Virginia bed and breakfast rentals, rent houses in Roanoke, bed and breakfast rentals Roanoke Virginia, and Roanoke Virginia condo rentals.
Espy, recognize, and recognize house rentals Portsmouth Virginia, for rent by owner homes Portsmouth Virginia, and Portsmouth vacation homes for rent by owner.
See romantic advertisements, hidden advertisements, city listed properties, and convenient ad directories that rental property owners and rental property owners post on this extensive website, FRBO.com.
Light upon and originate rental houses in Norfolk United States and rental homes.
Discern, move, and discover bed and breakfast rentals Williamsburg and Williamsburg Virginia homes for rent.
Subordinates, migrants, and natives who are investigating rental apartment Chancellor and are trying to ferret out Chancellor Virginia home rentals and rental properties in Chancellor Virginia can root our online website, FRBO.com and our city lists of marked properties and ski in/out advertisements.
Exotic directories and studio classifieds rent house Buena Vista, Buena Vista homes for rent by owner, rental apartment Buena Vista, and condo rentals.
Displaced persons and navigators who are wishing to observe and move or simply distinguish information can use FRBO.Com, For Rent By Owner,.
We started and devised FRBO.Com, For Rent By Owner, to be enticing, fine, and sightly.
Identify and catch rental houses in Woodstock and homes for rent by owner in Woodstock.
Disclose and find out Lignum rent houses and rental home Lignum United States.
Join our exclusive listings, studio listed properties, penthouse listed properties, and lake classifieds mailing list for rental properties Chancellor Virginia, for rent by owner homes in Chancellor Virginia, and rental apartment in Chancellor Virginia.
Devise, move, and uncover apartment rentals Lanexa United States, Lanexa United States vacation homes for rent by owner, and rental homes.
Glimpse and ascertain the vicinity and contiguous Chancellor Virginia section.
Chancellor Virginia details could facilitate, work for, and expedite your perquisition.
Debunk and glimpse rent house in Accomac United States and houses for rent Accomac United States.
Find, notice, and ascertain vacation rentals in Prince George Virginia, Prince George Virginia rental homes, vacation rentals in Prince George Virginia, and condo rentals Prince George.
|
|
