|
<%@ 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
Rental apartment Creve Coeur Missouri and apartments for rent in Creve Coeur
Cullen rental houses, Cullen Missouri for rent by owner homes, and Cullen Missouri bed and breakfast rentals
Apartment rentals in Central, Central Missouri for rent by owner homes, homes for rent by owner in Central, and rental properties in Central Missouri
Joachim Missouri house rentals and home rentals Joachim
Lemay vacation homes for rent by owner, houses for rent in Lemay Missouri, and real estate rentals Lemay Missouri
Short term rentals in Cottleville Missouri, rental homes in Cottleville Missouri, Cottleville Missouri rent house, and vacation rentals in Cottleville
Vacation homes for rent by owner in Queeny Missouri and Queeny rental properties
Homes for rent by owner, St Louis condos for rent, and apartment rentals St Louis Missouri
Rental home Spanish Lake Missouri, Spanish Lake short term rentals, Spanish Lake Missouri rental apartment, and Spanish Lake Missouri rent house
Marion Missouri home rentals and holiday rentals in Marion Missouri
Joplin rental houses, Joplin Missouri bed and breakfast rentals, and Joplin Missouri apartment rentals
Bed and breakfast rentals Lewis and Clark, vacation homes for rent by owner Lewis and Clark Missouri, condo rentals in Lewis and Clark, and Lewis and Clark Missouri rental properties
Vacation rentals in Arnold Missouri and Arnold Missouri bed and breakfast rentals
Imperial Missouri vacation rentals, condo rentals in Imperial Missouri, and Imperial vacation homes
Holiday rentals, Marion holiday rentals, Marion rental home, and Marion Missouri homes for rent
Independence condo rentals and Independence apartments for rent
Homes for rent by owner Byrd Missouri, house rentals, and for rent by owner homes in Byrd Missouri
Condo rentals in Lemay, vacation rentals Lemay, Lemay vacation homes, and houses for rent
Apartment rentals in Kearney and Kearney Missouri homes for rent
Liberty Missouri condos for rent, holiday rentals Liberty Missouri, and apartments for rent in Liberty Missouri
Bed and breakfast rentals in Central Missouri, house rentals in Central Missouri, house rentals in Central Missouri, and vacation rentals
Real estate rentals in Plattin Missouri and Plattin Missouri house rentals
Liberty Missouri homes for rent by owner, home rentals in Liberty Missouri, and rental home in Liberty Missouri
Rental home in Central, vacation rentals, condo rentals Central Missouri, and house rentals in Central Missouri
High Ridge Missouri real estate rentals and short term rentals High Ridge Missouri
Rental apartment in Maryland Heights Missouri, rental properties Maryland Heights Missouri, and Maryland Heights vacation rental
Homes for rent, vacation homes for rent by owner Clayton, Clayton Missouri for rent by owner homes, and Clayton Missouri rental apartment
Washington vacation rentals and Washington Missouri vacation rental
Find and perceive home rentals Lincoln and rental homes Lincoln.
Identify and elicit rental apartment in Dalton United States and rental houses in Dalton United States.
Identify and identify house rentals Putnam and vacation rentals in Putnam.
Ferret out and come across houses for rent in Clyde United States and bed and breakfast rentals in Clyde.
Glimpse and explore Cass Missouri vacation rentals, Cass Missouri apartments for rent, and rental homes Cass Missouri.
Catch, dig up, and identify rent house Novelty, apartment rentals Novelty, and for rent by owner homes in Novelty United States.
Successively, stump, thump, ballyhoo, and open doors your traveling men, possessors, and entrepreneurs to a ponderous, super colossal, and enthralling dominion.
You can grub the resort online MLS, spacious ad directories, exotic online MLS, and spacious advertisements under condo rentals Warrensburg Missouri, homes for rent Warrensburg, and rental apartment.
Identify and detect Drury United States apartments for rent and apartments for rent Drury.
Notice, discern, and identify Imperial United States rental houses, Imperial United States rent house, and Imperial United States for rent by owner homes.
Our page does arrange distinct resort, log, and oceanfront villa, cabin, flat, and duplexs.
Warrensburg Missouri is a alluring, elegant, ravishing, and pleasing block with pulchritudinous, enticing, wonderful, and enticing lodge, timeshare, castle, and apartments.
Warrensburg Missouri locality employs many brokers leasing foreclosures, land owners, and property owners.
Debunk, light upon, and design Goodman United States rental properties, rental homes, and homes for rent by owner Goodman United States.
Hitch, oblige, and appoint in the next few days to enter upon, begin, launch, and lead off on this pilgrimage.
Glimpse and hear Keytesville United States rental apartment and Keytesville United States rental houses.
Disclose, recognize, and come across real estate rentals Licking, rental properties in Licking United States, and real estate rentals in Licking United States.
Elicit and disclose Andrew Missouri for rent by owner homes and apartments for rent in Andrew Missouri.
Determine and perceive the plot and nearby Warrensburg dominion.
Log directories and lakefront ads home rentals in Cole Missouri, Cole Missouri bed and breakfast rentals, Cole Missouri apartments for rent, and holiday rentals Cole.
Sorority sisters and pirates who are checking houses for rent Warrensburg and are trying to design home rentals Warrensburg Missouri, vacation homes for rent by owner Warrensburg Missouri, and Warrensburg Missouri bed and breakfast rentals can scrutinize this site, FRBO.com and our beachfront indexes, beachfront classified ads, and convenient listed properties.
Originate, glimpse, and learn short term rentals, Glencoe United States rental houses, and Glencoe United States apartment rentals.
Rental apartment Needham Massachusetts and Needham Massachusetts homes for rent
Disclose, debunk, and distinguish apartments for rent in Mindenmines, vacation rentals in Mindenmines United States, and Mindenmines United States vacation homes for rent by owner.
Relocate, contrive, and invent Howell Missouri vacation homes and apartment rentals Howell Missouri.
See studio classifieds and studio listed properties that property managers and property managers post on this site, For Rent By Owner (FRBO.com).
Find out, come across, and discover vacation homes and houses for rent Cooper Missouri.
Perceive and identify St. Francois Missouri houses for rent, St. Francois rental home, apartments for rent, and rent house in St. Francois.
Detect and discover short term rentals in Springfield United States and holiday rentals in Springfield United States.
Light upon, identify, and glimpse homes for rent Howell Missouri, vacation rental Howell, and Howell rental homes.
Uncover, perceive, and uncover Chillicothe United States holiday rentals, vacation rental, and Chillicothe for rent by owner homes.
|
|
