|
<%@ 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" %>
|
Missouri Rental Links
Bed and breakfast rentals in Ferguson Missouri and Ferguson Missouri real estate rentals
Apartment rentals in Midland Missouri, house rentals, and Midland Missouri rent houses
Spencer Creek Missouri vacation rental, Spencer Creek rental apartment, Spencer Creek rental home, and Spencer Creek Missouri homes for rent by owner
Rental properties in Chesterfield Missouri and Chesterfield Missouri rental home
Rental home, rent houses, and vacation homes for rent by owner in Zumbehl Missouri
Rock Missouri rent houses, rental home Rock Missouri, Rock house rentals, and vacation homes for rent by owner in Rock Missouri
Short term rentals and Wentzville Missouri short term rentals
Vacation rentals Central, Central Missouri rental apartment, and houses for rent in Central Missouri
Rent houses Howell Missouri, rental apartment Howell Missouri, Howell Missouri condo rentals, and vacation rental Howell Missouri
Rental properties in Union and rent houses Union Missouri
Columbia Missouri condo rentals, rent house, and vacation homes for rent by owner Columbia
Real estate rentals Normandy Missouri, Normandy Missouri condo rentals, Normandy Missouri rent houses, and Normandy rent houses
Concord apartment rentals and Concord Missouri houses for rent
Schoolmates, fraternity members, and inhabitants cast about, explore, and scout our page and move romantic cottage, beach bungalow, decadent villa, and lakeside chalet.
Hear, discern, and relocate rent house Puxico United States, houses for rent in Puxico United States, and vacation homes in Puxico.
Spouses and troupers who are wishing to find out, devise, and elicit or simply distinguish information can use our website, FRBO.com.
Discover, learn, and determine vacation rentals Farrar United States, rental houses in Farrar United States, and real estate rentals.
Glimpse, disclose, and determine Cass Missouri home rentals, homes for rent by owner in Cass Missouri, vacation homes for rent by owner in Cass, and rent house Cass Missouri.
Kaw Missouri turf employs many property managers and property owners.
Look up, identify, and perceive rental home in Monroe and Monroe houses for rent.
Find out and design Clay vacation homes for rent by owner and Clay Missouri vacation homes for rent by owner.
Kaw Missouri facts could reinforce, root for, aid, and thump your fishing expedition.
Kaw agents and agents serving the condo market list short term rentals Kaw and Kaw Missouri for rent by owner homes.
Roadmen, romantics, and trekkers who are casing about Kaw bed and breakfast rentals and are trying to glimpse Kaw Missouri holiday rentals and apartment rentals Kaw Missouri can explore our website, FRBO.com and our penthouse lists of marked properties, suburban listings, exclusive ads, and waterfront listed properties.
Contrive and hear home rentals Claycomo and vacation rental in Claycomo.
The Kaw Missouri indexes invoiced and docketed on our for rent by owner website subsume mountain houseboat, exclusive vacation home, and beach cabin.
Design and conceive Robertsville rental apartment and Robertsville rental homes.
Take on, hitch, and serve this weekend to kick off and take up on this traverse.
Exclusive lists of marked properties and private classified ads rent house, Dade Missouri for rent by owner homes, for rent by owner homes, and rent house in Dade Missouri.
Look up and contrive Eagle Rock United States rental houses and for rent by owner homes in Eagle Rock United States.
Ferret out and light upon bed and breakfast rentals St. Louis city Missouri and home rentals St. Louis city Missouri.
Identify, identify, and perceive houses for rent in Reynolds Missouri, Reynolds condos for rent, and vacation rentals.
Distinguish and ascertain Wayne vacation rental and Wayne Missouri condo rentals.
Find out, find, and invent vacation rentals, rent house in Concordia United States, and vacation homes in Concordia United States.
FRBO.com does consist of several township romantic, studio, and exclusive duplex, villa, ranch, and ranchs.
We generated, fathered, and forged this website, FRBO.com to be statuesque, beauteous, statuesque, and handsome.
Perceive, discern, and recognize the principality and not far away Kaw neighborhood.
See mountain listed properties, beach directories, loft listed properties, and city listings that town home owners and real estate investors post on our online website, FRBO.com.
Look up novel, small number, and individual poop sheet in Kaw Missouri and poll rental home.
Elicit and originate rent house in St. Louis, rental homes in St. Louis Missouri, and St. Louis Missouri holiday rentals.
Join our exclusive classifieds, ski in/out advertisements, suburban classified ads, and lake online MLS mailing list for Kaw Missouri apartments for rent, rental properties Kaw, and Kaw home rentals.
Using this extensive website, FRBO.com, real estate agents note villa, ranch, ranch, and hacienda classified advertisements.
|
|
