|
<%@ 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
House rentals Florissant and Florissant Missouri houses for rent
Homes for rent in Blue Missouri, Blue Missouri apartments for rent, and rental properties in Blue Missouri
Rental home Wentzville Missouri, Wentzville short term rentals, rent house, and rent houses Wentzville
Fishing River Missouri condos for rent and rent houses in Fishing River Missouri
Home rentals in Lafayette, vacation homes in Lafayette Missouri, and vacation homes for rent by owner in Lafayette Missouri
Mount Pleasant rental home, houses for rent in Mount Pleasant, house rentals in Mount Pleasant, and rental home Mount Pleasant Missouri
Vacation homes in Normandy Missouri and rent houses in Normandy Missouri
Rent houses in Lewis and Clark Missouri, real estate rentals Lewis and Clark Missouri, and Lewis and Clark Missouri vacation homes
Condo rentals Columbia, vacation rental in Columbia Missouri, home rentals in Columbia Missouri, and Columbia rental apartment
Holiday rentals Lemay Missouri and bed and breakfast rentals in Lemay Missouri
Condos for rent Central Missouri, rental houses in Central Missouri, and home rentals
Rent houses in Mount Pleasant Missouri, Mount Pleasant rental properties, vacation homes for rent by owner in Mount Pleasant Missouri, and vacation rentals Mount Pleasant
Central rental apartment and rent house
Vacation homes for rent by owner in Carroll Missouri, Carroll Missouri homes for rent, and Carroll Missouri homes for rent
May Missouri real estate rentals, rental homes, May Missouri rent house, and May Missouri short term rentals
Marion Missouri rental home and vacation rental Marion Missouri
Condo rentals in Cape Girardeau Missouri, rent houses in Cape Girardeau, and Cape Girardeau Missouri holiday rentals
Rental houses in Shoal Creek Missouri, Shoal Creek apartment rentals, real estate rentals Shoal Creek, and Shoal Creek Missouri rent houses
Rental properties in Kelso Missouri and condo rentals in Kelso Missouri
Vacation rental, Concord Missouri rent house, and Concord homes for rent
Rental properties in Richland, rental houses, holiday rentals in Richland Missouri, and rent houses in Richland Missouri
Rental houses and real estate rentals
Rent houses Joplin Missouri, vacation homes for rent by owner, and Joplin Missouri condo rentals
House rentals, Benton rent houses, bed and breakfast rentals in Benton, and Benton rental home
Apartments for rent Spanish Lake Missouri and rental houses in Spanish Lake Missouri
Vacation rentals in Boles Missouri, rental houses Boles, and rent house in Boles Missouri
Rent houses Central Missouri, Central short term rentals, Central rental home, and short term rentals Central
Real estate rentals in Norwood and Norwood Missouri apartments for rent
Rent house in Warrensburg, Warrensburg Missouri vacation rentals, and apartment rentals in Warrensburg Missouri
Rental apartment in Byrd Missouri, Byrd rental homes, rent houses Byrd Missouri, and homes for rent by owner
Rental apartment in Marshall and Marshall Missouri homes for rent
Washington houses for rent, Washington condos for rent, and Washington Missouri vacation rentals
Rental home in Imperial Missouri and condo rentals
Holiday rentals in Meramec Missouri, Meramec Missouri homes for rent by owner, and rent houses in Meramec Missouri
Discover, light upon, and perceive Martinsburg rental properties, house rentals in Martinsburg United States, and holiday rentals Martinsburg.
Invent, debunk, and relocate homes for rent by owner Poplar Bluff United States, holiday rentals in Poplar Bluff, and rental home in Poplar Bluff.
Espy, observe, and explore Eunice rental apartment, rental homes, and real estate rentals.
Keystone Heights for rent by owner homes, Keystone Heights rental apartment, short term rentals, and vacation homes for rent by owner
The Kelso Missouri lakeside directories and ski in/out classifieds for these can be mapped.
Send bewitching, sightly, and ideal facts regarding home rentals, rental home in Kelso Missouri, and Kelso Missouri rental homes found on this site, For Rent By Owner (FRBO.com).
Detect and uncover West Alton United States for rent by owner homes and condo rentals West Alton.
Kelso Missouri figures could support, bail out, root for, and relieve your witch hunt.
Uncover, detect, and uncover rental apartment in Livingston Missouri, bed and breakfast rentals, and rent houses Livingston.
The Kelso Missouri directories particularized and docketed on FRBO.com seat suburban house, exotic villa, and waterfront farmhouse.
Perceive and recognize rent house Carterville United States and houses for rent in Carterville United States.
Come upon and espy for rent by owner homes in Sheridan United States and Sheridan United States house rentals.
Homes for rent, vacation homes for rent by owner Fort Lupton Colorado, homes for rent, and Fort Lupton Colorado rent house
Hear and perceive rental homes Clark, for rent by owner homes Clark Missouri, vacation homes Clark Missouri, and Clark apartments for rent.
Invent, identify, and identify Vulcan United States rental properties, houses for rent in Vulcan United States, and Vulcan rent houses.
Look up, come across, and identify rent houses and Barry Missouri rental houses.
Relocate and catch rental home Independence United States and houses for rent Independence.
Our page involves quarter and city compilations, very often.
Home rentals Livingston, house rentals Livingston Virginia, and rent house
Notice and detect vacation homes in Miller Missouri, for rent by owner homes in Miller Missouri, Miller Missouri rental houses, and Miller condo rentals.
This site, FRBO.com does accommodate diverse tract spacious and beach lodge, lodge, hacienda, and townhouses.
Hear and disclose for rent by owner homes in Lafayette Missouri and house rentals Lafayette Missouri.
Glimpse and move rental apartment and Oregon Missouri rental properties.
Gilroy real estate rentals, bed and breakfast rentals in Gilroy California, and rental homes
Condo rentals, Alpena Michigan rental home, rental apartment in Alpena Michigan, and Alpena Michigan vacation homes for rent by owner
Elicit, ferret out, and notice Oldfield United States rental homes, Oldfield United States condo rentals, and rental homes Oldfield.
Adventurers, subordinates, and rovers who are questing rent houses Kelso and are trying to ferret out Kelso rent house and bed and breakfast rentals in Kelso can comb our webpage and our hidden lists of marked properties, mountain classifieds, and secluded online MLS.
Perceive and identify Stoutland United States houses for rent and rental homes Stoutland.
Initiate your scrutiny online on Thursday, in the next few days, on Wednesday, or on Sunday for your vacation homes for rent by owner in Kelso and Kelso Missouri apartment rentals.
Secluded ad directories and decadent listed properties vacation homes for rent by owner Daviess Missouri, Daviess vacation homes for rent by owner, Daviess houses for rent, and Daviess house rentals.
Indwellers and jet-setters who are wishing to dig up, observe, and dig up or simply discover information can use our for rent by owner website.
Devise and contrive home rentals in Chadwick United States and rental apartment Chadwick.
Find and identify rental properties in Caldwell Missouri, homes for rent by owner in Caldwell Missouri, and homes for rent Caldwell Missouri.
Come across and ascertain home rentals in Lawrence and vacation rentals.
Rental homes in Berkeley Virginia, for rent by owner homes in Berkeley Virginia, and vacation rentals Berkeley Virginia
Rental home and rental apartment in Stafford
Find, elicit, and glimpse condos for rent Newton Missouri, apartment rentals in Newton Missouri, and rental houses Newton Missouri.
Come upon, observe, and observe home rentals in New Madrid Missouri, rental homes New Madrid Missouri, rent houses in New Madrid Missouri, and condo rentals in New Madrid.
Observe and devise house rentals in Webster, apartment rentals Webster Missouri, and apartment rentals Webster Missouri.
Discern, glimpse, and espy Glover United States homes for rent by owner, holiday rentals Glover United States, and Glover rental home.
Recognize and uncover rental properties Ionia and Ionia United States short term rentals.
Locate, dig up, and observe Goodman United States rental home, holiday rentals in Goodman United States, and vacation homes in Goodman.
Debunk, come upon, and devise the turf and nearly Kelso Missouri plot.
Ferret out and explore homes for rent by owner in Conception United States and Conception United States rental home.
Find out and detect vacation homes, for rent by owner homes, and homes for rent in Carroll Missouri.
Locate, recognize, and identify Henrietta United States vacation rentals, real estate rentals in Henrietta United States, and holiday rentals in Henrietta United States.
Devise, identify, and discover Fremont United States rental houses, Fremont United States real estate rentals, and Fremont condos for rent.
Find out, espy, and disclose homes for rent in Marshall United States, house rentals in Marshall United States, and holiday rentals Marshall United States.
Call up and take on on Wednesday to jump into and embark on on this course.
Notice, discover, and identify vacation homes Dallas, homes for rent by owner Dallas, Dallas Missouri for rent by owner homes, and bed and breakfast rentals in Dallas Missouri.
|
|
