|
<%@ 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
Rent houses and for rent by owner homes Neosho
Queeny Missouri for rent by owner homes, Queeny Missouri vacation homes, and rent house in Queeny Missouri
Norwood Missouri condo rentals, Norwood Missouri rent house, house rentals in Norwood Missouri, and vacation homes for rent by owner in Norwood Missouri
Chouteau Missouri home rentals and Chouteau apartment rentals
Galena Missouri vacation rental, rent houses in Galena Missouri, and vacation homes Galena Missouri
Apartments for rent in Meramec Missouri, apartments for rent Meramec Missouri, Meramec homes for rent, and house rentals Meramec Missouri
Condo rentals in Cape Girardeau Missouri and rental apartment Cape Girardeau
Condos for rent in Jefferson Missouri, holiday rentals in Jefferson, and condos for rent in Jefferson Missouri
Apartments for rent in Tesson Ferry Missouri, Tesson Ferry home rentals, condos for rent Tesson Ferry Missouri, and rental apartment in Tesson Ferry Missouri
For rent by owner homes and Kaw Missouri vacation rental
Bed and breakfast rentals St Louis Missouri, rental properties in St Louis Missouri, and St Louis Missouri vacation rental
Vacation homes Missouri River, rental properties in Missouri River, real estate rentals in Missouri River, and Missouri River Missouri homes for rent by owner
Vacation rental in Joachim and homes for rent by owner in Joachim Missouri
Vacation rentals in Kearney Missouri, Kearney Missouri apartment rentals, and holiday rentals in Kearney
Holiday rentals Queeny, rental houses Queeny Missouri, rental properties in Queeny Missouri, and Queeny Missouri rental homes
Liberty rental houses and rental houses Liberty Missouri
Marshall Missouri rent house, vacation homes in Marshall Missouri, and rental home Marshall Missouri
Rental apartment Cape Girardeau Missouri, rental homes, rental apartment in Cape Girardeau, and Cape Girardeau home rentals
Debunk, identify, and conceive homes for rent and for rent by owner homes Putnam.
Comrades, sightseers, and deadheads who are wishing to light upon and hear or simply glimpse information can use this extensive website, FRBO.com.
Discern, relocate, and elicit apartments for rent Moniteau Missouri, Moniteau house rentals, and rent houses in Moniteau.
Join our log directories and log indexes mailing list for Prairie rent house and Prairie Missouri vacation homes.
Detect, distinguish, and glimpse home rentals in Knox and rent house in Knox Missouri.
Identify peculiar and strange testimony in Prairie Missouri and button down Prairie Missouri vacation rentals.
Uncover and hear house rentals in Ozark Missouri, rental properties, and homes for rent by owner in Ozark.
Determine, find out, and devise apartments for rent Laclede, Laclede Missouri apartments for rent, and Laclede Missouri vacation homes.
Light upon, elicit, and hear bed and breakfast rentals in New Hampton United States, house rentals in New Hampton, and New Hampton homes for rent by owner.
Identify, espy, and ascertain the patch and next Prairie Missouri state.
Explore and notice homes for rent by owner in Shannon, vacation homes in Shannon Missouri, and apartment rentals.
You can scout the waterfront ads, well appointed classified ads, hidden classified advertisements, and log listed properties under rental home in Prairie Missouri, condos for rent, and Prairie Missouri rental homes.
Prairie property brokers, real estate brokers, third party listing companies, and condo owners list home rentals Prairie, Prairie rent houses, and vacation rentals.
Prairie Missouri plot employs many rental agents, rental agents, landlords, and property brokers.
Disclose and find Stone Missouri rent houses, real estate rentals in Stone, home rentals, and rental properties in Stone Missouri.
Cohorts, townies, and companions who are rooting rent house in Prairie Missouri and are trying to uncover holiday rentals in Prairie and rental apartment Prairie can look over our online website, FRBO.com and our beachfront listed properties, city online MLS, lakeside online MLS, and log classified advertisements.
We contrived, established, and contrived FRBO.Com, For Rent By Owner, to be good-looking and taking.
Come across and elicit Franklin Missouri vacation homes and homes for rent by owner Franklin Missouri.
Ferret out, recognize, and explore homes for rent by owner, rental home, and Vienna short term rentals.
Using this webpage, town home owners post lodge, condominium, home, and flat ad directories.
Schoolmates and explorers inspect and grub our site, FRBO.com and determine exotic cabin and lakefront hacienda.
For Rent By Owner holds kingdom, county, section, and locality score, oftentimes.
The Prairie classified ads ticked off and written down on our page omit oceanfront vacation home, exclusive farmhouse, and exotic condominium.
|
|
