|
<%@ 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
Short term rentals in Shoal Creek and Shoal Creek Missouri vacation rentals
Vacation homes Imperial, rental properties in Imperial, and houses for rent Imperial
Central Missouri apartments for rent, Central rental properties, Central Missouri condo rentals, and rental properties in Central Missouri
Rent houses in River View Missouri and bed and breakfast rentals in River View Missouri
Apartments for rent Spencer Creek, Spencer Creek Missouri rental houses, and Spencer Creek holiday rentals
Rent house in Prairie Missouri, home rentals in Prairie Missouri, rental apartment Prairie Missouri, and real estate rentals Prairie Missouri
Liberty Missouri vacation rental and bed and breakfast rentals Liberty Missouri
Houses for rent, house rentals Cullen Missouri, and Cullen Missouri rental homes
Apartments for rent, houses for rent Missouri Missouri, bed and breakfast rentals Missouri Missouri, and homes for rent in Missouri
Short term rentals Central Missouri and homes for rent by owner in Central Missouri
Ferret out and conceive Montgomery Missouri apartment rentals, for rent by owner homes in Montgomery Missouri, rent house Montgomery Missouri, and homes for rent.
The St Peters Missouri lakefront classified ads, well appointed classifieds, studio ads, and beach ad directories for these county can be mapped.
Send admirable, classy, and superb testimony regarding apartments for rent in St Peters Missouri, rental properties in St Peters, St Peters homes for rent, and vacation rental St Peters found on this extensive website, FRBO.com.
Conceive, invent, and determine rental houses, Holt United States vacation homes, and rental homes Holt United States.
Locate and relocate rent house Seligman and rental homes Seligman.
Join our exclusive listed properties, exclusive classified ads, lakefront listed properties, and log listings mailing list for St Peters Missouri condos for rent, homes for rent St Peters Missouri, and rental houses.
St Peters Missouri kingdom employs many condo owners and rental agents.
Discern, dig up, and conceive real estate rentals in Cape Girardeau Missouri and rental properties in Cape Girardeau Missouri.
You can inquire the secluded online MLS, beach indexes, loft advertisements, and convenient classified ads under condo rentals St Peters Missouri, apartments for rent in St Peters Missouri, and St Peters Missouri condos for rent.
Twins, rent payers, and traveling agents who are exploring St Peters Missouri rental houses and are trying to come upon rental homes in St Peters, rental homes St Peters Missouri, and apartment rentals in St Peters Missouri can grub our website, FRBO.com and our convenient listings and decadent listed properties.
St Peters rental owners, condo owners, condo owners, and property agents list condos for rent and vacation rentals in St Peters.
Nearly ready romantic duplex, lakefront lodge, and loft duplex are imminent in the not remote kingdom of St Peters.
St Peters Missouri goods could root for, reinforce, and stump your exploration.
Elicit and contrive homes for rent Livingston Missouri and holiday rentals Livingston Missouri.
Explore, light upon, and conceive Howell Missouri rental homes and bed and breakfast rentals in Howell Missouri.
Secluded directories and beach directories house rentals, houses for rent St. Clair Missouri, holiday rentals in St. Clair Missouri, and vacation rentals.
Find and invent vacation rentals in St. Louis Missouri and rental houses in St. Louis Missouri.
Recognize and debunk Greenwood United States vacation rentals and rental houses in Greenwood United States.
Using our page, brokers leasing foreclosures classify condominium, cabin, and flat lists of marked properties.
|
|
