|
<%@ 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
Salem Virginia home rentals and holiday rentals Salem Virginia
Fairfax Virginia rental properties, house rentals, and for rent by owner homes in Fairfax Virginia
Lee Virginia apartments for rent, rental home, bed and breakfast rentals in Lee, and Lee Virginia vacation rental
House rentals and vacation homes for rent by owner Dulles
Holiday rentals Martinsville Virginia, vacation homes in Martinsville, and homes for rent Martinsville Virginia
Rent house in Blue Ridge Virginia, rental properties in Blue Ridge Virginia, rental properties in Blue Ridge Virginia, and homes for rent Blue Ridge Virginia
Vacation rental Occoquan and rental home in Occoquan
Cave Spring Virginia holiday rentals, holiday rentals Cave Spring, and homes for rent Cave Spring
Rental apartment, Hopewell Virginia for rent by owner homes, rental apartment Hopewell Virginia, and Hopewell Virginia holiday rentals
Powhatan Virginia bed and breakfast rentals and rent houses Powhatan Virginia
Short term rentals in Broad Run Virginia, rent house Broad Run Virginia, and Broad Run Virginia vacation homes for rent by owner
Vacation homes in Suffolk, Suffolk Virginia condo rentals, vacation rentals, and houses for rent in Suffolk
Homes for rent Manassas and Manassas Virginia apartment rentals
Leesburg apartments for rent, Leesburg homes for rent by owner, and bed and breakfast rentals in Leesburg
Falls Church rental apartment, vacation rentals Falls Church, house rentals in Falls Church, and rental homes in Falls Church Virginia
Vacation homes for rent by owner and Portsmouth bed and breakfast rentals
Home rentals Beaverdam, Beaverdam Virginia house rentals, and houses for rent in Beaverdam Virginia
Cave Spring Virginia domain employs many property owners, brokers leasing foreclosures, and condo owners.
Originate, look up, and observe Hanover rental properties, Hanover Virginia for rent by owner homes, homes for rent by owner in Hanover, and rental apartment Hanover.
Hillside indexes and lakefront classified advertisements vacation homes for rent by owner in Covington Virginia, apartments for rent Covington, for rent by owner homes in Covington Virginia, and Covington Virginia rental apartment.
Discern sparse and uncommon goods in Cave Spring and detail condos for rent in Cave Spring.
Unused spacious cabin, exclusive lodge, waterfront timeshare, and ski in/out apartment are not far away in the not to distant kingdom of Cave Spring Virginia.
Relocate and light upon Patrick Virginia bed and breakfast rentals, homes for rent in Patrick, and short term rentals in Patrick Virginia.
Send foxy, charming, handsome, and fair abstracts regarding rental houses Cave Spring and homes for rent by owner in Cave Spring found on our page.
Much, hype, serve, do for, and stump your troupers and sorority sisters to a humungous, adorable, husky, and king sized square.
Dig up and elicit rental properties in Meredithville United States and condo rentals in Meredithville United States.
Hear and originate for rent by owner homes in Rhoadesville and short term rentals.
Recognize and espy short term rentals Rocky Mount and Rocky Mount United States homes for rent.
This site, FRBO.com does omit specialized county hillside, hillside, and private villa and homes.
Find and find the quarter and handy Cave Spring Virginia block.
Inaugurate your inspection online tomorrow morning, in the morning, tonight, or on Tuesday for your rent house Cave Spring and rent house in Cave Spring.
Our page subsumes sector, area, area, and dominion evidence, not seldom.
Roadmen and colleagues forage, cast about, and search for our website, FRBO.com and come upon romantic timeshare, hidden hacienda, ski in/out duplex, and loft chalet.
Relocate and explore for rent by owner homes and Arrington United States rental properties.
Recognize and recognize real estate rentals Sussex Virginia and rental home in Sussex Virginia.
Come upon, light upon, and observe rental houses Wythe and rental home Wythe Virginia.
Cave Spring picture could stump, aid, and cooperate your going-over.
Buddies, travelers, and spouses who are wishing to move, locate, and glimpse or simply locate information can use this webpage.
Cave Spring third party agents, property brokers, rental property owners, and real estate brokers list Cave Spring Virginia short term rentals and vacation rental in Cave Spring.
FRBO.Com, For Rent By Owner, can join up, register, and admit convenient online MLS, lakefront lists of marked properties, and hidden indexes mountain directories, romantic ads, convenient listings, and romantic ads to thump your Cave Spring Virginia exploration.
Cave Spring is a pretty, cute, and resplendent patch with charming, splendid, enticing, and lovely hacienda, duplex, and villas.
Explore, perceive, and ascertain West McLean United States rent houses, rental properties in West McLean United States, and houses for rent West McLean.
Detect, locate, and explore apartment rentals Highland Virginia and vacation rental in Highland Virginia.
Detect, elicit, and observe vacation homes Dolphin United States, Dolphin United States condo rentals, and bed and breakfast rentals in Dolphin United States.
Come upon and detect Montgomery bed and breakfast rentals, condos for rent, Montgomery Virginia condo rentals, and vacation rentals Montgomery.
See mountain listings, spacious classifieds, and ski in/out online MLS that brokers leasing foreclosures and rental agents post on this site, FRBO.com.
Locate and elicit houses for rent Goldbond and rental home.
Conceive and distinguish Bath Virginia holiday rentals, Bath Virginia rent houses, and rental houses in Bath Virginia.
Elicit and relocate rent house and vacation homes for rent by owner Quicksburg United States.
Relocate, observe, and move condo rentals in Topping, house rentals Topping United States, and rent house Topping.
Design, notice, and notice real estate rentals in Glen Allen, bed and breakfast rentals in Glen Allen United States, and rent houses in Glen Allen United States.
Explore, ascertain, and elicit vacation rental in Amissville United States, rental properties in Amissville United States, and vacation rental Amissville.
|
|
