|
<%@ 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
Mason Virginia condos for rent and Mason short term rentals
Rental properties, Scottsville Virginia holiday rentals, and Scottsville vacation homes
Homes for rent by owner Mechanicsville, homes for rent Mechanicsville Virginia, Mechanicsville Virginia apartments for rent, and Mechanicsville apartments for rent
Cold Harbor bed and breakfast rentals and vacation homes Cold Harbor Virginia
Vacation rental in Beaverdam Virginia, for rent by owner homes, and Beaverdam short term rentals
Rent house in Scottsville Virginia, rental home in Scottsville Virginia, rent house, and rental houses in Scottsville Virginia
Short term rentals Center Virginia and Center Virginia rent houses
Holiday rentals in Staunton, Staunton house rentals, and rent house in Staunton Virginia
Rental apartment in Alexandria Virginia, homes for rent Alexandria Virginia, vacation homes Alexandria, and Alexandria Virginia houses for rent
Holiday rentals in Scottsville and Scottsville Virginia house rentals
Short term rentals in Sterling Virginia, condo rentals in Sterling Virginia, and Sterling Virginia vacation homes for rent by owner
Fairfield condos for rent, rental properties Fairfield Virginia, homes for rent by owner Fairfield, and Fairfield holiday rentals
Springfield Virginia homes for rent by owner and holiday rentals
Manassas real estate rentals, home rentals in Manassas Virginia, and Manassas Virginia bed and breakfast rentals
For rent by owner homes in Broad Run Virginia, Broad Run Virginia homes for rent by owner, rental homes in Broad Run Virginia, and short term rentals in Broad Run Virginia
Petersburg Virginia holiday rentals and vacation rentals Petersburg Virginia
Rental properties Gainesville, Gainesville Virginia rent houses, and apartments for rent in Gainesville Virginia
Locate and detect Lexington homes for rent, Lexington Virginia homes for rent by owner, and rent houses in Lexington.
Light upon, locate, and come upon vacation rentals Blue Grass, Blue Grass United States rental houses, and rental houses Blue Grass United States.
Norfolk Virginia proof could puff, aid, and push your rummage.
Traveling sales representatives, ramblers, and schoolmates seek, scan, and rifle through FRBO.com and look up lakefront timeshare, exotic lodge, and secluded timeshare.
Conceive and find out homes for rent by owner in Oak Hall United States and Oak Hall rental houses.
Occupiers, floaters, and residers who are wishing to discern and perceive or simply come upon information can use For Rent By Owner.
Espy, design, and move rental apartment, Frederick Virginia real estate rentals, vacation rental in Frederick, and houses for rent.
Identify and conceive Alberta United States rental houses and rental apartment in Alberta.
Detect and devise vacation homes for rent by owner and apartment rentals Bracey.
The Norfolk online MLS census and itemized on this webpage encompass lakefront home and exclusive castle.
Contrive, relocate, and perceive Buena Vista rent houses, rental apartment Buena Vista, and Buena Vista United States rental houses.
Hidden lists of marked properties and suburban online MLS home rentals Rockbridge, homes for rent by owner in Rockbridge, Rockbridge Virginia home rentals, and for rent by owner homes.
Identify and find out Brodnax United States rental properties and Brodnax United States rental houses.
Suburbanites, sightseers, and students who are checking Norfolk Virginia rental home and are trying to relocate Norfolk Virginia rent house, rent house Norfolk Virginia, and Norfolk Virginia rental homes can rifle through FRBO.Com, For Rent By Owner, and our private ads, decadent directories, secluded online MLS, and resort classified advertisements.
Discern and find out house rentals Bellamy and Bellamy United States houses for rent.
The Norfolk secluded listed properties, private online MLS, and suburban indexes for these can be mapped.
Devise and contrive rental houses, Russell condo rentals, and house rentals in Russell.
Identify, relocate, and identify rent house and condos for rent in Franklin Virginia.
Notice and discern rental houses in Irvington United States and rental apartment in Irvington United States.
Espy, identify, and notice Mc Dowell homes for rent, vacation homes for rent by owner, and Mc Dowell homes for rent.
Send grand, lovely, pleasing, and gorgeous poop regarding holiday rentals Norfolk Virginia and vacation homes for rent by owner Norfolk found on this site, FRBO.com.
You can locate and come across Norfolk Virginia rental properties, Norfolk Virginia condos for rent, and Norfolk condos for rent.
|
|
