|
<%@ 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
Home rentals in Plattin Missouri and Plattin Missouri rental houses
Homes for rent by owner in Chouteau, Chouteau houses for rent, and vacation rentals in Chouteau Missouri
Chouteau homes for rent by owner, homes for rent, Chouteau Missouri rental home, and rental homes Chouteau Missouri
Rent house in Friedens and houses for rent in Friedens
Vacation homes for rent by owner in University Missouri, condo rentals University Missouri, and houses for rent
Holiday rentals in Bonhomme Missouri, Bonhomme Missouri rental home, apartments for rent Bonhomme, and apartment rentals in Bonhomme Missouri
Rent houses Harvester and vacation homes in Harvester
Rental homes Mason, homes for rent by owner in Mason Missouri, and Mason real estate rentals
Rental apartment in Spanish Lake Missouri, holiday rentals Spanish Lake Missouri, bed and breakfast rentals in Spanish Lake Missouri, and rental home Spanish Lake
Clayton holiday rentals and apartments for rent Clayton Missouri
Condos for rent, Cape Girardeau Missouri real estate rentals, and condos for rent in Cape Girardeau Missouri
Holiday rentals in Imperial Missouri, rental apartment in Imperial Missouri, rent house in Imperial, and Imperial Missouri rental home
Rental properties St Ferdinand and rental homes St Ferdinand
Conceive and devise Seneca United States vacation homes and vacation rentals in Seneca.
You can grub the spacious indexes and beach classified advertisements under Creve Coeur Missouri for rent by owner homes, house rentals in Creve Coeur, and bed and breakfast rentals in Creve Coeur Missouri.
Locate and invent Hickory Missouri condo rentals and Hickory Missouri short term rentals.
Find out and move houses for rent in Vienna and vacation rental in Vienna United States.
Come upon, identify, and notice real estate rentals in Douglas Missouri, rental houses in Douglas Missouri, Douglas Missouri vacation homes, and Douglas vacation homes for rent by owner.
Find out and originate homes for rent and Stanberry home rentals.
Originate your legwork online next week, on Tuesday, or this weekend for your Creve Coeur Missouri home rentals and rent house Creve Coeur Missouri.
Notice ad hoc and individual evidence in Creve Coeur and register condo rentals in Creve Coeur Missouri.
Explore and design rental home in St. Louis Missouri, homes for rent St. Louis Missouri, vacation homes for rent by owner St. Louis Missouri, and for rent by owner homes in St. Louis.
Infrequently, cooperate, help, push, and boost your traveling salesmen and voyagers to a enticing, roomy, extensive, and in favor vicinity.
Design, come upon, and look up condo rentals in Bates Missouri, rental houses in Bates, and vacation rentals in Bates Missouri.
Creve Coeur Missouri brass tacks could support, run interference, help, and bail out your inquest.
For Rent By Owner can volunteer and place exotic classifieds, hillside listings, and well appointed listed properties exclusive advertisements and suburban classified advertisements to assist your Creve Coeur Missouri pilgrimage.
Place, hire, and assign next weekend to lead off, launch, inaugurate, and originate on this hike.
Notice, invent, and ascertain Anniston bed and breakfast rentals, home rentals Anniston United States, and vacation rentals Anniston United States.
|
|
