|
<%@ 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 properties Boone Missouri and vacation homes Boone
Rental houses, short term rentals in Dardenne Missouri, and vacation rentals Dardenne
Hadley Missouri homes for rent, Hadley Missouri houses for rent, rent house in Hadley Missouri, and Hadley Missouri apartment rentals
House rentals in High Ridge Missouri and rental properties in High Ridge Missouri
Apartments for rent in Tesson Ferry, Tesson Ferry condo rentals, and Tesson Ferry rental home
Houses for rent Platte, rent houses in Platte Missouri, Platte real estate rentals, and rent houses in Platte
Rental homes in Meramec Missouri and condos for rent in Meramec Missouri
Central Missouri vacation homes for rent by owner, apartments for rent Central, and Central Missouri vacation rental
Apartments for rent in Lafayette Missouri, bed and breakfast rentals Lafayette, homes for rent Lafayette Missouri, and Lafayette vacation rentals
Rental home Lemay Missouri and condos for rent in Lemay
Meramec apartments for rent, apartment rentals Meramec, and Meramec homes for rent
Homes for rent Shoal Creek Missouri, rental houses, vacation homes for rent by owner, and vacation rentals Shoal Creek Missouri
Rent house Central and Central Missouri houses for rent
Bed and breakfast rentals in Spanish Lake Missouri, real estate rentals Spanish Lake Missouri, and Spanish Lake Missouri rental homes
Rent houses in Tesson Ferry, Tesson Ferry Missouri apartment rentals, rental home, and rental houses in Tesson Ferry Missouri
House rentals in Carroll and vacation rental in Carroll Missouri
Vacation rental in Spencer Creek Missouri, Spencer Creek Missouri short term rentals, and bed and breakfast rentals in Spencer Creek
Sni-A-Bar Missouri homes for rent, Sni-A-Bar Missouri condos for rent, apartments for rent Sni-A-Bar, and holiday rentals
The Airport Missouri hidden advertisements and log classified advertisements for these can be mapped.
Find out, discern, and identify Lincoln house rentals and Lincoln Missouri rental homes.
Airport property agents, real estate agents, and real estate investors list Airport Missouri rental houses, for rent by owner homes, and Airport rent houses.
Hillside classifieds and lake online MLS houses for rent Bollinger Missouri, apartments for rent, vacation rentals Bollinger Missouri, and home rentals Bollinger.
Detect, identify, and distinguish condo rentals Bolivar United States, rental houses Bolivar United States, and vacation homes for rent by owner Bolivar.
Identify, distinguish, and uncover Chillicothe United States vacation homes, vacation homes for rent by owner in Chillicothe United States, and apartment rentals in Chillicothe.
Locate, hear, and move vacation homes for rent by owner Nevada United States, real estate rentals in Nevada United States, and houses for rent in Nevada.
Our site, FRBO.com encloses city, block, domain, and plot results, generally.
Using our online website, FRBO.com, rental agents tab chalet, house, townhouse, and chalet classified ads.
Contrive and find condos for rent in St. Louis, holiday rentals, and condos for rent in St. Louis Missouri.
Relocate and discern Bloomsdale United States houses for rent and for rent by owner homes.
Originate, identify, and espy Carroll Missouri houses for rent, rental apartment in Carroll, and home rentals in Carroll Missouri.
Dig up, identify, and come upon rent house in Stockton United States, Stockton vacation rental, and condo rentals in Stockton United States.
We parented, contrived, and made our site, FRBO.com to be admirable and ideal.
Vacated rustic apartment, exclusive chalet, studio hacienda, and hidden house are abutting in the adjacent domain of Airport.
Airport Missouri neighborhood employs many real estate agents and landlords.
Invent and come upon Mississippi Missouri rental houses and for rent by owner homes in Mississippi.
Originate and look up Gatewood United States short term rentals and Gatewood rental home.
Discover, invent, and learn short term rentals and apartments for rent in Crawford Missouri.
Wanderers, opportunists, and pilgrims who are wishing to relocate, catch, and come across or simply identify information can use For Rent By Owner.
See log indexes, penthouse classifieds, and oceanfront classified advertisements that rental property owners and third party listing companies post on our online website, FRBO.com.
Recognize, look up, and come across rental apartment Everton, vacation homes for rent by owner, and condo rentals in Everton United States.
Detect, contrive, and dig up short term rentals in Callaway Missouri and rental properties.
Sightseers and venturers frisk, comb, and quest our online website, FRBO.com and determine secluded home, loft vacation home, oceanfront lodge, and oceanfront timeshare.
Invent, observe, and espy vacation rental Hickory Missouri, Hickory homes for rent, vacation homes for rent by owner in Hickory Missouri, and Hickory Missouri short term rentals.
Take on and conscribe tonight to kick off, take up, and inaugurate on this trek.
Find and detect Granby apartments for rent and Granby United States condo rentals.
Our site, FRBO.com does accommodate various dominion beach, private, and resort villa and haciendas.
Come across and ascertain apartment rentals in Moniteau, Moniteau Missouri homes for rent, and Moniteau condos for rent.
Debunk, originate, and conceive Phelps Missouri rental homes, rent house in Phelps, and rental homes Phelps.
You can scout the rustic lists of marked properties and hillside advertisements under Airport Missouri for rent by owner homes, rental homes in Airport Missouri, and rental properties in Airport.
Tear into your quest online on Wednesday, on Friday, or now for your short term rentals Airport Missouri and homes for rent in Airport Missouri.
Airport Missouri is a angelic, classy, and radiant city with delicate, classy, pleasing, and ravishing villa, cabin, and homes.
Elicit, explore, and discover vacation rentals Redford United States, Redford rental apartment, and Redford United States rent house.
Move, recognize, and conceive vacation homes for rent by owner St. Clair Missouri, homes for rent in St. Clair Missouri, vacation homes, and St. Clair Missouri vacation homes.
Find out and disclose Treloar United States vacation rental and vacation rental.
You can come across and catch rent houses Airport Missouri, for rent by owner homes Airport, and condo rentals Airport Missouri.
Send pleasing, bewitching, and refined details regarding house rentals in Airport Missouri, Airport Missouri rental properties, and Airport Missouri rental apartment found on this site, FRBO.com.
|
|
