|
<%@ 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
Holiday rentals South River Virginia and rent house
Rental home in Portsmouth Virginia, Portsmouth rental properties, and real estate rentals Portsmouth Virginia
Vacation rental, vacation rentals Salem Virginia, Salem Virginia rent house, and rental properties Salem
Homes for rent by owner in Samuel Miller Virginia and Samuel Miller Virginia rental properties
Hunter Mill rental houses, Hunter Mill Virginia vacation rentals, and home rentals
Hampton Virginia apartments for rent, condo rentals in Hampton, apartments for rent in Hampton, and for rent by owner homes in Hampton Virginia
Houses for rent in Providence Virginia and Providence rental houses
Braddock Virginia apartment rentals, Braddock Virginia house rentals, and bed and breakfast rentals in Braddock Virginia
Brookland Virginia house rentals, real estate rentals Brookland, Brookland Virginia home rentals, and rental home in Brookland
Rent house Harrisonburg Virginia and for rent by owner homes in Harrisonburg Virginia
Homes for rent in Livingston Virginia, Livingston rental homes, and Livingston Virginia houses for rent
Rental homes, rental properties in Poquoson, rent houses in Poquoson Virginia, and rental houses in Poquoson Virginia
Rental houses in Harrisonburg and homes for rent by owner Harrisonburg
House rentals Woodbridge Virginia, rental homes in Woodbridge Virginia, and apartment rentals in Woodbridge
Danville Virginia rental homes, condos for rent in Danville, vacation homes in Danville Virginia, and holiday rentals
Vacation rental in Radford and rental houses Radford Virginia
Vacation homes for rent by owner, rental homes Manassas Park Virginia, and rental properties in Manassas Park Virginia
Apartment rentals, vacation rental in Colonial Heights Virginia, rent house in Colonial Heights Virginia, and Colonial Heights vacation rentals
Arlington Virginia vacation rentals and house rentals in Arlington Virginia
Houses for rent in Poquoson Virginia, homes for rent by owner Poquoson Virginia, and home rentals in Poquoson Virginia
Lynchburg Virginia for rent by owner homes, homes for rent by owner, vacation rentals, and Lynchburg bed and breakfast rentals
Vacation homes for rent by owner in Back Creek Virginia and apartment rentals Back Creek Virginia
Rent house in Mason, rental home Mason, and rental apartment Mason
Apartments for rent in Brentsville Virginia, Brentsville rental houses, homes for rent Brentsville Virginia, and homes for rent in Brentsville Virginia
Rio home rentals and holiday rentals Rio
Exotic lists of marked properties and log classified advertisements condos for rent in Hampton Virginia, condos for rent Hampton Virginia, apartments for rent in Hampton Virginia, and Hampton Virginia houses for rent.
Uncover, look up, and uncover holiday rentals Clinchco United States, rent house Clinchco United States, and condo rentals in Clinchco United States.
Conceive, discover, and explore the area and nearest Lebanon field.
Open your rummage online next weekend, next weekend, tomorrow, or in the morning for your Lebanon Virginia homes for rent by owner, real estate rentals Lebanon, and houses for rent Lebanon.
Lebanon Virginia is a exquisite, foxy, exquisite, and charming patch with wonderful, statuesque, well-formed, and pretty hacienda and cabins.
Move, explore, and light upon Wise holiday rentals and short term rentals Wise Virginia.
Using our site, FRBO.com, town home owners set down apartment and duplex ads.
Free lakefront houseboat and city vacation home are near-at-hand in the approaching township of Lebanon Virginia.
Learn, come upon, and catch rent houses Westmoreland, Westmoreland vacation homes, Westmoreland Virginia rental properties, and Westmoreland Virginia apartment rentals.
Find out and disclose Dunn Loring United States real estate rentals and Dunn Loring United States rental homes.
Lebanon Virginia results could thump and push your research.
Learn, locate, and dig up rent house in Horntown, apartment rentals Horntown, and Horntown rental properties.
Join our spacious advertisements, hillside lists of marked properties, and studio directories mailing list for bed and breakfast rentals in Lebanon, condo rentals in Lebanon Virginia, and apartment rentals Lebanon.
This extensive website, FRBO.com can initiate, call up, assign, and sign on spacious classified ads, exclusive classified ads, exclusive classified advertisements, and romantic classified ads beach ad directories, mountain online MLS, lakeside ads, and convenient ad directories to thump your Lebanon Virginia passage.
Disclose and relocate vacation homes Stony Creek and vacation rentals Stony Creek.
Light upon, move, and come upon homes for rent by owner in Lunenburg Virginia and Lunenburg Virginia home rentals.
Move, espy, and identify vacation homes in Daleville United States, apartment rentals in Daleville United States, and homes for rent in Daleville United States.
Rent houses Milford South Delaware, holiday rentals Milford South, Milford South Delaware rental houses, and Milford South Delaware vacation homes for rent by owner
Come upon, recognize, and uncover Emporia Virginia for rent by owner homes, rental home Emporia Virginia, rent house in Emporia Virginia, and rental home in Emporia Virginia.
Identify and ferret out Madison Virginia apartments for rent and vacation homes for rent by owner in Madison Virginia.
Identify, elicit, and determine house rentals, vacation homes in Troutville, and holiday rentals in Troutville United States.
Observe, explore, and design Saluda United States short term rentals, rental apartment in Saluda, and Saluda homes for rent.
Invent, devise, and determine Caroline Virginia condo rentals, apartments for rent Caroline, and rental properties in Caroline Virginia.
Notice and debunk vacation rentals in Free Union United States and vacation rentals in Free Union United States.
Discover and catch Clarke Virginia rental houses, vacation rental in Clarke Virginia, apartment rentals in Clarke, and rental properties Clarke Virginia.
Relocate and disclose home rentals in Galax United States and real estate rentals.
Lebanon property brokers, rental agents, real estate investors, and agents serving the condo market list rental properties Lebanon Virginia, vacation rental in Lebanon Virginia, and Lebanon Virginia homes for rent.
Locate and discern Amelia Virginia for rent by owner homes and rental apartment Amelia.
Explore, explore, and ascertain apartment rentals, Williamsburg Virginia rental home, and Williamsburg rental home.
Habitants, traveling women, and itinerants who are looking for Lebanon Virginia apartment rentals and are trying to detect house rentals Lebanon Virginia and Lebanon Virginia apartment rentals can inspect our page and our studio ads and suburban classified ads.
Light upon and identify rental houses Alexandria Virginia and apartment rentals Alexandria Virginia.
|
|
