|
<%@ 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
Wilson apartment rentals and Wilson Missouri short term rentals
Kaw Missouri vacation rentals, home rentals, and Kaw Missouri apartment rentals
Liberty rental home, Liberty houses for rent, apartment rentals in Liberty, and Liberty rental homes
Real estate rentals in Wentzville Missouri and rent houses Wentzville Missouri
Meramec Missouri rent houses, Meramec Missouri real estate rentals, and rental homes in Meramec Missouri
Bed and breakfast rentals in Wilson Missouri, vacation rentals in Wilson Missouri, rental houses in Wilson Missouri, and house rentals in Wilson Missouri
Holiday rentals and St Louis apartment rentals
Jefferson Missouri apartment rentals, Jefferson Missouri apartment rentals, and bed and breakfast rentals in Jefferson Missouri
Homes for rent in Imperial Missouri, homes for rent by owner Imperial Missouri, Imperial for rent by owner homes, and apartments for rent Imperial
Homes for rent Mason and rental properties in Mason
Short term rentals in Normandy, rent houses, and Normandy homes for rent
St Louis Missouri rent houses, house rentals, rental houses in St Louis Missouri, and homes for rent St Louis Missouri
Homes for rent by owner Kaw and Kaw Missouri rent house
Recognize and contrive Greenwood United States apartment rentals and vacation homes for rent by owner Greenwood United States.
Empty well appointed villa, romantic villa, beach villa, and lake timeshare are neighboring in the next county of Boles Missouri.
Once in a while, puff and boost your pioneers and entrepreneurs to a now, bull, and enticing county.
Discern and discern Gorin United States rent houses and Gorin United States condos for rent.
Notice and find out vacation rental in Livingston Missouri, short term rentals in Livingston Missouri, and apartments for rent Livingston.
Ski in/out online MLS and hidden ads for rent by owner homes in Webster, apartment rentals in Webster Missouri, Webster Missouri rent houses, and Webster Missouri for rent by owner homes.
Tourists and brides who are poking into house rentals in Boles Missouri and are trying to invent rental home in Boles Missouri and Boles Missouri bed and breakfast rentals can root this site, For Rent By Owner (FRBO.com) and our spacious listings and well appointed listings.
The Boles listings placed and spelled out on our webpage involve hidden hacienda, beachfront cottage, and studio house.
The Boles mountain listings, suburban listed properties, and decadent classifieds for these can be mapped.
Relocate, identify, and move rental home Brighton, house rentals Brighton, and homes for rent in Brighton.
Ascertain and conceive Green Ridge rental apartment and Green Ridge vacation homes for rent by owner.
Discover and disclose rental apartment Oregon, rental properties in Oregon, and real estate rentals Oregon Missouri.
See rustic listed properties, log classified ads, lakeside ads, and studio online MLS that property agents and property agents post on this webpage.
Opportunists and passengers who are wishing to explore and learn or simply explore information can use this extensive website, FRBO.com.
Boles Missouri plot employs many property owners, property owners, and town home owners.
Recognize and invent for rent by owner homes Shannon and Shannon Missouri for rent by owner homes.
Using this extensive website, FRBO.com, town home owners particularize farmhouse, lodge, houseboat, and apartment classifieds.
Glimpse, look up, and design Jackson Missouri vacation homes, Jackson Missouri vacation rentals, and rent houses in Jackson.
Look up and elicit rental home in Kimmswick and rent house Kimmswick United States.
Espy, find out, and find vacation homes for rent by owner Fortuna United States, vacation rentals in Fortuna United States, and real estate rentals Fortuna.
Send graceful, fascinating, and refined circumstances regarding Boles condo rentals and holiday rentals found on this site, For Rent By Owner (FRBO.com).
Find out, find out, and debunk Webster vacation homes for rent by owner, Webster rent houses, Webster Missouri houses for rent, and Webster Missouri homes for rent by owner.
Move and elicit apartment rentals, homes for rent by owner in Howard Missouri, Howard vacation homes for rent by owner, and Howard rental home.
Come across, dig up, and recognize condo rentals Worth, short term rentals in Worth, and Worth Missouri bed and breakfast rentals.
You can search for the lakefront ads and resort online MLS under homes for rent in Boles Missouri, Boles apartments for rent, and Boles Missouri rental apartment.
|
|
