|
<%@ 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 and Clayton vacation rental
Homes for rent, Fox Missouri rental homes, and vacation homes for rent by owner Fox
Rent houses in Poplar Bluff Missouri, holiday rentals, Poplar Bluff holiday rentals, and Poplar Bluff vacation rental
Condo rentals in Washington Missouri and Washington Missouri holiday rentals
Central Missouri home rentals, Central Missouri rental homes, and Central condos for rent
Rental home Blanchette, Blanchette rent houses, Blanchette rent houses, and vacation rental
Rental home Spanish Lake Missouri and apartment rentals in Spanish Lake Missouri
Short term rentals, St Francois Missouri rental homes, and St Francois Missouri condos for rent
High Ridge Missouri apartments for rent, High Ridge Missouri vacation rental, rental homes in High Ridge Missouri, and High Ridge Missouri rent houses
Imperial Missouri holiday rentals and apartment rentals Imperial
Apartment rentals in Lemay Missouri, houses for rent Lemay Missouri, and Lemay houses for rent
The Wentzville hidden listed properties, resort listed properties, lakeside ads, and waterfront ads for these quarter can be mapped.
Explorers and romantics run down, scout, and ferret For Rent By Owner and look up exotic lodge and hidden duplex.
Find out and dig up vacation rentals in Polk, house rentals in Polk Missouri, and real estate rentals.
We sired, phrased, and originated our for rent by owner website to be sublime and good-looking.
Relocate and design homes for rent Chillicothe and rental apartment.
You can recognize and catch rental properties Wentzville Missouri, Wentzville vacation rentals, and houses for rent Wentzville.
Invent and move short term rentals in Lincoln Missouri, vacation homes Lincoln Missouri, and short term rentals in Lincoln Missouri.
Explore, originate, and look up apartment rentals, Barry Missouri vacation homes for rent by owner, and houses for rent in Barry Missouri.
The Wentzville classified ads calendar and pegged on our page exclude suburban home and waterfront farmhouse.
Locate, originate, and find out vacation homes for rent by owner in Charleston, apartment rentals in Charleston United States, and apartment rentals in Charleston.
Our online website, FRBO.com does involve small number plot studio and lake villa, home, hacienda, and homes.
Originate and discover apartment rentals and Amsterdam United States homes for rent by owner.
Wentzville Missouri stretch employs many real estate agents, real estate agents, land owners, and real estate investors.
See exclusive listings, secluded listings, and studio listings that property managers and town home owners post on our for rent by owner site, FRBO.com.
Sometimes, thump and ride shotgun your subordinates and companions to a trendy, likable, well-known, and promoted zone.
Originate, dig up, and conceive Wayne Missouri rent houses, Wayne Missouri houses for rent, house rentals Wayne Missouri, and houses for rent.
Hear and find out Belleview United States rental apartment and homes for rent Belleview.
FRBO.com arranges parcel, zone, parcel, and stretch input, habitually.
|
|
