|
<%@ 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
Rental homes in Alexandria Virginia and rent houses
Vacation rentals, Plains Virginia for rent by owner homes, and house rentals Plains Virginia
Rental properties in Bermuda Virginia, vacation rentals in Bermuda Virginia, Bermuda rental apartment, and rental houses
Vacation homes for rent by owner in Falls Church and rent house
Blue Ridge Virginia vacation homes for rent by owner, Blue Ridge for rent by owner homes, and for rent by owner homes in Blue Ridge Virginia
Holiday rentals in Sully Virginia, house rentals Sully, Sully Virginia for rent by owner homes, and Sully Virginia rental houses
Tuckahoe Virginia house rentals and apartments for rent
South River rental properties, South River real estate rentals, and apartment rentals in South River Virginia
Apartments for rent in Springfield Virginia, Springfield Virginia rental properties, Springfield short term rentals, and Springfield Virginia short term rentals
For rent by owner homes in Stonewall Virginia and rental homes Stonewall
Homes for rent in South Anna Virginia, bed and breakfast rentals in South Anna Virginia, and rental homes in South Anna
George Washington houses for rent, apartment rentals George Washington Virginia, short term rentals George Washington Virginia, and holiday rentals in George Washington
Home rentals in Martinsville and real estate rentals
Rent houses in Varina, Varina Virginia apartments for rent, and rent houses in Varina
Holiday rentals in Rivanna Virginia, vacation homes Rivanna Virginia, Rivanna vacation homes, and Rivanna Virginia vacation homes for rent by owner
Short term rentals Jefferson Virginia and vacation homes for rent by owner in Jefferson Virginia
Lee Virginia houses for rent, Lee condos for rent, and Lee Virginia rental properties
Elicit distinctive and uncommon abstracts in Bland and inscribe Bland homes for rent.
Recognize, relocate, and elicit rent house, Loudoun Virginia vacation homes for rent by owner, rent houses in Loudoun Virginia, and rental properties.
Hear and explore bed and breakfast rentals Cartersville and vacation homes for rent by owner Cartersville United States.
Explore and find out vacation homes Midlothian United States and Midlothian condo rentals.
Glimpse, ascertain, and discern vacation homes in Fries, condo rentals Fries, and vacation rentals in Fries United States.
Perceive and determine houses for rent in Buckingham Virginia and rental apartment in Buckingham.
Using this site, FRBO.com, real estate brokers census lodge, villa, hacienda, and cottage classifieds.
Elicit, look up, and ferret out home rentals in Washington Virginia and vacation rental.
Unused studio cottage, log vacation home, well appointed lodge, and exclusive houseboat are not far away in the not faraway domain of Bland Virginia.
Detect and catch house rentals and Richmond Virginia house rentals.
Itinerants, expeditionists, and occupiers search for and study this webpage and identify city cottage and city timeshare.
Not seldom, assist and aid your companions and confidants to a praised, suitable, full, and enthralling principality.
Bland real estate brokers, property agents, brokers leasing foreclosures, and town home owners list vacation homes for rent by owner Bland, rent houses in Bland, house rentals in Bland Virginia, and rent house in Bland Virginia.
Glimpse, determine, and come upon apartment rentals Pulaski, Pulaski vacation rentals, and Pulaski United States apartments for rent.
Discover, ferret out, and catch Meadows of Dan rental houses, Meadows of Dan rental houses, and rental properties Meadows of Dan.
Move, devise, and recognize holiday rentals in Pearisburg United States, rent house in Pearisburg United States, and condo rentals in Pearisburg United States.
Find, determine, and look up rental home, rental apartment in Norfolk Virginia, and real estate rentals in Norfolk.
Identify and look up homes for rent by owner Poquoson Virginia and Poquoson house rentals.
Devise, notice, and design Lynchburg Virginia rental properties and condos for rent in Lynchburg.
See hillside advertisements and beachfront listed properties that land owners and rental property owners post on our page.
Move and perceive apartments for rent in Orange Virginia, vacation homes for rent by owner in Orange Virginia, and rental houses.
|
|
