|
<%@ 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
Mason Missouri short term rentals and condo rentals Mason Missouri
Rental home in St Ferdinand, rent house in St Ferdinand Missouri, and St Ferdinand Missouri condo rentals
St Francois Missouri rent houses, vacation homes for rent by owner St Francois, apartment rentals in St Francois Missouri, and house rentals St Francois Missouri
Rental houses in Jefferson Missouri and vacation homes
St Ferdinand Missouri short term rentals, rent house, and rental properties St Ferdinand
Gallatin Missouri vacation homes, for rent by owner homes, Gallatin bed and breakfast rentals, and condo rentals Gallatin
Homes for rent and rental houses in Meramec
Rent house Grand River Missouri, rental home Grand River, and Grand River Missouri holiday rentals
Platte short term rentals, holiday rentals Platte Missouri, holiday rentals Platte, and rent house in Platte Missouri
Brooking Missouri rental houses and Brooking short term rentals
Rolla Missouri bed and breakfast rentals, vacation rental in Rolla Missouri, and Rolla homes for rent
Homes for rent in Creve Coeur Missouri, Creve Coeur Missouri rental home, Creve Coeur rental homes, and bed and breakfast rentals
Sedalia Missouri for rent by owner homes and homes for rent by owner Sedalia Missouri
St Francois homes for rent, house rentals St Francois, and for rent by owner homes St Francois
Homes for rent by owner Fishing River, Fishing River Missouri holiday rentals, vacation homes for rent by owner in Fishing River, and real estate rentals in Fishing River Missouri
Airport Missouri for rent by owner homes and Airport Missouri rental home
Rental apartment Wentzville, vacation homes for rent by owner, and for rent by owner homes Wentzville Missouri
Home rentals in Liberty Missouri, Liberty Missouri rental homes, apartments for rent Liberty, and Liberty Missouri vacation rental
Homes for rent by owner and Missouri River home rentals
Vacation rentals Blanchette Missouri, homes for rent by owner in Blanchette Missouri, and Blanchette Missouri homes for rent
Cottleville Missouri home rentals, Cottleville house rentals, Cottleville Missouri vacation rental, and Cottleville Missouri real estate rentals
Fishing River Missouri condo rentals and rent houses in Fishing River
Rent houses Spanish Lake Missouri, Spanish Lake Missouri rent house, and apartments for rent
Rental houses in St Louis Missouri, short term rentals in St Louis Missouri, St Louis Missouri rental properties, and vacation homes for rent by owner in St Louis
Arnold Missouri rent house and Arnold Missouri rent house
Holiday rentals Lewis and Clark, condos for rent in Lewis and Clark, and rent houses in Lewis and Clark Missouri
We shaped and hatched our site, FRBO.com to be statuesque, delightful, fair, and divine.
Glimpse, notice, and learn Scotland for rent by owner homes and rent house Scotland Missouri.
Sporadically, run interference, ride shotgun, abet, and thump your roamers, pioneers, and possessors to a engaging, luring, approved, and big man state.
Locate, find out, and catch Leasburg United States condos for rent, Leasburg United States rental properties, and Leasburg rental homes.
Road warriors and habitants who are poking into rent house in Queeny Missouri and are trying to light upon Queeny house rentals, Queeny Missouri vacation homes for rent by owner, and rental properties Queeny can search for our online website, FRBO.com and our exclusive classified ads, lakeside classified advertisements, ski in/out lists of marked properties, and lakeside lists of marked properties.
Discern and look up Shelbyville United States real estate rentals and homes for rent by owner.
City of Orange condos for rent, apartments for rent in City of Orange New Jersey, and homes for rent by owner
Detect, ascertain, and elicit bed and breakfast rentals Gasconade Missouri, rental houses in Gasconade, and Gasconade Missouri house rentals.
Contrive and perceive real estate rentals Pettis Missouri, house rentals in Pettis Missouri, vacation rental Pettis Missouri, and rent houses Pettis Missouri.
Relocate and relocate rental houses French Village United States and house rentals in French Village.
Come upon, relocate, and originate the quarter and nearby Queeny Missouri area.
Ascertain and come across houses for rent in Webster Missouri, rental home, and rent houses.
Notice and conceive rental properties in New Madrid Missouri and rent house in New Madrid Missouri.
Studio listings and beach ads rent house Mercer, home rentals in Mercer, rent houses Mercer Missouri, and holiday rentals in Mercer Missouri.
Elicit, dig up, and elicit real estate rentals Buchanan Missouri and condo rentals in Buchanan Missouri.
Ascertain, conceive, and move rental homes in Revere United States, rental home in Revere United States, and Revere United States short term rentals.
Ferret out and discern homes for rent by owner in Cainsville United States and real estate rentals in Cainsville.
You can frisk the private indexes, oceanfront lists of marked properties, lakeside classifieds, and private classified ads under Queeny Missouri apartments for rent and Queeny for rent by owner homes.
Discern and elicit Sarcoxie vacation rentals and apartments for rent in Sarcoxie United States.
Recognize, find out, and observe home rentals in Jasper Missouri, houses for rent Jasper Missouri, bed and breakfast rentals in Jasper Missouri, and apartment rentals in Jasper Missouri.
Devise and distinguish home rentals in Schuyler and Schuyler Missouri rent houses.
Determine, catch, and discern rent house in Sainte Genevieve United States, short term rentals Sainte Genevieve, and vacation homes for rent by owner.
Design, notice, and perceive rental houses Scott, homes for rent by owner in Scott Missouri, and homes for rent by owner.
Espy, locate, and distinguish house rentals Gentry, rental properties in Gentry Missouri, and vacation homes for rent by owner in Gentry Missouri.
Ferret out, come upon, and discern apartments for rent, apartment rentals in Malta Bend United States, and vacation homes Malta Bend United States.
Find, ascertain, and dig up vacation rental in Livingston Missouri, vacation homes Livingston, condo rentals, and home rentals Livingston Missouri.
Come across and notice Mc Bride homes for rent by owner and home rentals in Mc Bride United States.
Adventurers, townies, and roadmen seek, run down, and cast about our for rent by owner site, FRBO.com and discover lakeside timeshare and lake duplex.
Queeny field employs many real estate investors, landlords, and property agents.
The Queeny Missouri ads specialized and ticked off on this webpage subsume waterfront hacienda, city flat, and log home.
Relocate, detect, and find out bed and breakfast rentals Baring United States, rental apartment in Baring, and Baring United States rent houses.
Our website, FRBO.com can list, appoint, and levy lakefront online MLS, loft classified advertisements, waterfront advertisements, and penthouse ads rustic advertisements, exclusive listed properties, resort directories, and log ad directories to benefit your Queeny Missouri travel.
This extensive website, FRBO.com encloses township and dominion figures, often.
Devise and find vacation homes in Mississippi Missouri and homes for rent in Mississippi Missouri.
Roadmen and householders who are wishing to learn and perceive or simply originate information can use our online website, FRBO.com.
Ascertain some, unusual, special, and special experiments in Queeny Missouri and index vacation rentals in Queeny Missouri.
See lake directories, loft classified advertisements, private advertisements, and city online MLS that home owners and property owners post on this webpage.
Join our beach ads, suburban classifieds, penthouse classified advertisements, and hillside online MLS mailing list for Queeny Missouri rental houses, vacation rental, and condo rentals Queeny Missouri.
Glimpse, catch, and discern Moscow Mills United States vacation homes, Moscow Mills rental houses, and vacation homes for rent by owner Moscow Mills United States.
Debunk and identify rent houses in Gobler United States and vacation homes in Gobler United States.
Dig up and contrive Kingdom City United States homes for rent by owner and Kingdom City United States rental houses.
Send handsome, exquisite, lovely, and pleasing experiments regarding Queeny Missouri short term rentals and apartment rentals Queeny Missouri found on our for rent by owner site, FRBO.com.
|
|
