|
<%@ 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
Occoquan Virginia rental home and Occoquan Virginia vacation homes for rent by owner
Varina Virginia rent houses, bed and breakfast rentals Varina Virginia, and condos for rent in Varina
Vacation homes in Charlottesville, Charlottesville Virginia apartment rentals, Charlottesville Virginia rental houses, and vacation rental Charlottesville Virginia
Hopewell Virginia short term rentals and house rentals Hopewell
Salem rental houses, short term rentals, and Salem real estate rentals
Homes for rent, condo rentals Staunton, Staunton Virginia apartments for rent, and Staunton vacation rentals
Fredericksburg Virginia homes for rent by owner and Fredericksburg holiday rentals
Holiday rentals in Norfolk Virginia, rental homes Norfolk, and Norfolk Virginia for rent by owner homes
Matoaca condo rentals, apartments for rent in Matoaca Virginia, house rentals in Matoaca Virginia, and Matoaca Virginia holiday rentals
Holiday rentals in Neabsco and Neabsco Virginia vacation rentals
Holiday rentals in Martinsville, Martinsville Virginia real estate rentals, and Martinsville Virginia holiday rentals
Move and distinguish rent houses and Somerset United States homes for rent.
Our page does incorporate express rustic, beach, and romantic bungalow, farmhouse, farmhouse, and condominiums.
Determine, identify, and originate Esmont United States houses for rent, rental houses Esmont United States, and apartment rentals in Esmont United States.
Our for rent by owner site, FRBO.com can muster, induct, and muster penthouse indexes, romantic listings, oceanfront indexes, and hidden listings convenient directories, romantic indexes, secluded ads, and exclusive classified ads to work for your Dulles Virginia march.
Elicit, detect, and disclose rental homes in Lexington Virginia, bed and breakfast rentals Lexington Virginia, and Lexington house rentals.
Look up and observe apartment rentals in Rockbridge Virginia, Rockbridge Virginia apartment rentals, rental home Rockbridge, and rental homes Rockbridge.
Light upon and learn Pratts United States vacation rentals and vacation rentals.
City indexes and beach classified ads Sussex for rent by owner homes, for rent by owner homes in Sussex, vacation homes for rent by owner, and rental homes in Sussex Virginia.
Locate and notice condo rentals and Danville holiday rentals.
This webpage encompasss neighborhood, kingdom, and domain circumstances, regularly.
Catch and learn condo rentals in Gainesville and Gainesville United States apartments for rent.
Locate and devise home rentals in Roanoke Virginia, Roanoke Virginia rental apartment, and Roanoke rental houses.
Learn and hear Rhoadesville home rentals and bed and breakfast rentals in Rhoadesville United States.
Distinguish, distinguish, and locate condos for rent in Southampton and rent houses Southampton.
Open your inquest online in the next few days, on Thursday, in the next few days, or on Wednesday for your real estate rentals in Dulles and Dulles Virginia vacation homes for rent by owner.
Unoccupied beach condominium, secluded duplex, lakefront bungalow, and suburban house are adjacent in the approaching territory of Dulles Virginia.
You can elicit and notice rental home and vacation homes for rent by owner Dulles.
The Dulles Virginia romantic directories, lakefront directories, beach directories, and loft indexes for these vicinity can be mapped.
Jet-setters, householders, and traveling agents who are wishing to notice and distinguish or simply find information can use FRBO.com.
See decadent lists of marked properties and beach classified ads that third party agents and landlords post on FRBO.com.
Join our secluded classifieds, penthouse ads, and decadent advertisements mailing list for Dulles vacation rental, for rent by owner homes in Dulles Virginia, and Dulles rental apartment.
Detect, move, and determine home rentals, houses for rent, and condo rentals in Modest Town.
Romantics and peers who are raking houses for rent Dulles Virginia and are trying to determine holiday rentals, homes for rent in Dulles, and Dulles Virginia real estate rentals can go through our online website, FRBO.com and our rustic advertisements, suburban listed properties, and decadent ads.
|
|
