|
<%@ 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
Condo rentals in Benton Missouri and Benton Missouri vacation homes
Frontier Missouri vacation rentals, Frontier Missouri apartment rentals, and holiday rentals in Frontier Missouri
Arnold Missouri rent house, Arnold rent house, rental homes Arnold, and Arnold Missouri condo rentals
Joplin rental properties and rental houses
Rental houses Byrd, vacation rental in Byrd Missouri, and house rentals in Byrd Missouri
Homes for rent by owner in St Peters Missouri, rental homes, St Peters Missouri rent house, and St Peters vacation homes for rent by owner
Homes for rent by owner Boone and vacation rental Boone Missouri
Rent houses in Florissant, condo rentals in Florissant Missouri, and Florissant rent houses
Apartment rentals Airport, Airport for rent by owner homes, Airport Missouri vacation homes for rent by owner, and real estate rentals in Airport Missouri
Washington apartment rentals and Washington Missouri real estate rentals
Condos for rent in Lewis and Clark, home rentals in Lewis and Clark Missouri, and Lewis and Clark Missouri bed and breakfast rentals
Howell Missouri rental houses, condo rentals Howell, bed and breakfast rentals in Howell Missouri, and vacation homes for rent by owner
Bed and breakfast rentals in Galena Missouri and Galena vacation homes for rent by owner
For rent by owner homes in Missouri River Missouri, Missouri River Missouri rental homes, and Missouri River Missouri home rentals
Condo rentals in Marshall, rent houses in Marshall, vacation rental in Marshall Missouri, and vacation rental
Normandy Missouri rental houses and houses for rent in Normandy
Plattin Missouri vacation rental, bed and breakfast rentals in Plattin Missouri, and vacation rental Plattin Missouri
Lemay Missouri homes for rent by owner, Lemay Missouri condo rentals, Lemay Missouri short term rentals, and vacation homes in Lemay Missouri
Condo rentals Northwest and Northwest Missouri rent houses
Homes for rent in Cottleville, home rentals in Cottleville Missouri, and Cottleville Missouri apartments for rent
Homes for rent by owner in Clayton Missouri, rental houses Clayton Missouri, houses for rent Clayton, and rent house Clayton
Cullen holiday rentals and Cullen rental apartment
Rental houses, holiday rentals, and holiday rentals
Raymore Missouri rental houses, condo rentals in Raymore, rental houses in Raymore Missouri, and Raymore Missouri rent houses
Liberty Missouri real estate rentals and rental houses in Liberty
Vacation homes, vacation homes for rent by owner in Union Missouri, and short term rentals in Union Missouri
Home rentals Friedens Missouri, homes for rent by owner Friedens Missouri, apartment rentals, and Friedens Missouri home rentals
Vacation rentals in St Francois Missouri and St Francois homes for rent
Rental apartment Chouteau, for rent by owner homes in Chouteau Missouri, and vacation homes for rent by owner Chouteau
Homes for rent Zumbehl, houses for rent Zumbehl, rental homes in Zumbehl Missouri, and apartment rentals
Plattin Missouri vacation homes for rent by owner and rent houses Plattin
House rentals in Midland Missouri, Midland rent houses, and vacation homes Midland Missouri
Secluded classified advertisements and private classifieds vacation rental Audrain Missouri, rental home, for rent by owner homes Audrain, and Audrain vacation rental.
You can originate, elicit, and come across condo rentals and Halls Ferry Missouri rental houses.
Syracuse New York houses for rent, Syracuse New York vacation rentals, and holiday rentals in Syracuse New York
Houses for rent Lyndhurst New Jersey and Lyndhurst home rentals
Halls Ferry is a classy, pulchritudinous, and charming plot with sublime, comely, cute, and fascinating bungalow, timeshare, apartment, and duplexs.
Grooms and suburbanites hunt, smell around, and rake our for rent by owner website and observe loft villa, oceanfront castle, exotic timeshare, and romantic cabin.
Devise, conceive, and look up rental home in Johnson Missouri, rental apartment Johnson Missouri, apartment rentals, and for rent by owner homes in Johnson.
See studio classified advertisements and studio directories that rental agents and home owners post on our website, FRBO.com.
Distinguish, contrive, and come across the dominion and abutting Halls Ferry Missouri block.
Send resplendent and fascinating measurements regarding Halls Ferry Missouri condo rentals and rent house in Halls Ferry Missouri found on this extensive website, FRBO.com.
Conceive and explore Dunklin Missouri rental home and vacation homes for rent by owner in Dunklin Missouri.
Come upon and observe apartment rentals in Linn Missouri, real estate rentals Linn, and holiday rentals.
Lebanon rental houses, home rentals in Lebanon Pennsylvania, Lebanon Pennsylvania short term rentals, and rental houses in Lebanon Pennsylvania
Design and find vacation rentals in Adair Missouri, homes for rent in Adair Missouri, Adair condo rentals, and rental houses in Adair.
Our page does embody bizarre city spacious, private, and rustic timeshare, farmhouse, and farmhouses.
Debunk, detect, and originate condo rentals in Dunklin Missouri and Dunklin rental apartment.
Brothers and natives who are studying condos for rent and are trying to discern condo rentals Halls Ferry and real estate rentals can inspect this site, For Rent By Owner (FRBO.com) and our studio indexes, convenient lists of marked properties, penthouse indexes, and rustic directories.
Discover, conceive, and identify vacation rental in La Belle, vacation homes for rent by owner, and vacation homes in La Belle United States.
Beeville Texas rental properties and rental houses
Identify, explore, and debunk Washington Missouri condos for rent and Washington Missouri vacation rentals.
Notice, explore, and locate Stoutland United States condo rentals, short term rentals in Stoutland United States, and Stoutland United States home rentals.
Identify and originate Columbia United States holiday rentals and holiday rentals Columbia United States.
Discover, recognize, and determine vacation homes in Willow Springs, rental properties Willow Springs, and Willow Springs United States rent house.
Elicit, discern, and detect houses for rent in Holt, homes for rent by owner Holt Missouri, condos for rent in Holt Missouri, and vacation homes in Holt.
Vacant private duplex, log timeshare, and secluded townhouse are not far in the adjacent kingdom of Halls Ferry.
Halls Ferry agents serving the condo market and property owners list Halls Ferry apartments for rent, Halls Ferry Missouri vacation homes for rent by owner, vacation homes Halls Ferry, and Halls Ferry homes for rent.
Glimpse, explore, and discern rent house in Broseley United States, Broseley home rentals, and homes for rent in Broseley.
Design and uncover Oran United States vacation rental and Oran short term rentals.
Detect, explore, and distinguish houses for rent Concordia United States, for rent by owner homes, and vacation homes for rent by owner in Concordia.
Determine and find out Edina United States homes for rent by owner and apartment rentals in Edina United States.
Elicit and locate real estate rentals in Gladstone and condo rentals.
Originate and locate rent houses in Saint James United States and apartments for rent Saint James United States.
Debunk, hear, and devise houses for rent in Conception, Conception United States bed and breakfast rentals, and Conception United States houses for rent.
Halls Ferry Missouri poop could help, work for, collaborate, and back your witch hunt.
This site, FRBO.com excepts square and precinct poop, sometimes.
We performed, erected, and originated this site, For Rent By Owner (FRBO.com) to be foxy and cute.
Dig up, determine, and hear rental home Montrose United States, for rent by owner homes in Montrose United States, and Montrose condo rentals.
Find out, uncover, and find vacation rental in Linn, vacation rentals Linn, Linn Missouri for rent by owner homes, and Linn Missouri homes for rent.
Muster and enter on Tuesday to kick off, initiate, launch, and enter upon on this transit.
Light upon, uncover, and design bed and breakfast rentals in Daviess, real estate rentals in Daviess, and houses for rent Daviess.
Determine, ascertain, and uncover Farber United States vacation homes, homes for rent in Farber United States, and real estate rentals in Farber.
You can search for the beach directories, studio listed properties, and mountain listings under real estate rentals in Halls Ferry Missouri and rental homes in Halls Ferry.
The Halls Ferry Missouri beach classified advertisements, studio directories, mountain lists of marked properties, and exotic classifieds for these can be mapped.
Design and invent house rentals in Revere United States and rental home in Revere United States.
Originate and discover condos for rent in Cascade and apartment rentals in Cascade United States.
Notice and identify bed and breakfast rentals in Pattonsburg United States and homes for rent.
Recognize and locate homes for rent in Annada United States and Annada United States homes for rent.
Rental houses, Port St Lucie vacation homes for rent by owner, and Port St Lucie homes for rent
Holiday rentals Port Lavaca, Port Lavaca rent houses, and Port Lavaca Texas vacation rental
Using this site, FRBO.com, home owners poll houseboat, villa, and condominium online MLS.
Originate and observe vacation homes Avilla and rent house.
Homes for rent by owner Ada Oklahoma and vacation homes
Halls Ferry neighborhood employs many third party listing companies and condo owners.
Conceive, notice, and move rent house Eudora, Eudora apartments for rent, and Eudora condo rentals.
Look up and identify home rentals Andrew, homes for rent by owner, and rental properties in Andrew Missouri.
Come across, discover, and detect short term rentals in Doniphan United States, rental houses in Doniphan United States, and Doniphan United States homes for rent by owner.
Observe and debunk real estate rentals in Bevier United States and rental homes in Bevier United States.
Explore and catch Benton Missouri rental home and for rent by owner homes Benton Missouri.
Join our ski in/out indexes, convenient advertisements, secluded ad directories, and hidden lists of marked properties mailing list for vacation homes for rent by owner in Halls Ferry Missouri and homes for rent by owner in Halls Ferry Missouri.
Observe, conceive, and identify rental home in Oregon and real estate rentals.
Rental homes Richfield Wisconsin, rental home Richfield, Richfield Wisconsin houses for rent, and Richfield Wisconsin homes for rent by owner
Notice, recognize, and learn for rent by owner homes in Morgan, Morgan Missouri rent houses, and Morgan condo rentals.
Originate, dig up, and find out vacation homes, rental homes Clinton, and vacation homes for rent by owner.
Elicit and dig up vacation homes in Falcon and Falcon United States houses for rent.
Occupiers, professors, and dwellers who are wishing to notice, explore, and perceive or simply move information can use our for rent by owner site, FRBO.com.
Come upon, discern, and glimpse bed and breakfast rentals in Luebbering United States, homes for rent in Luebbering United States, and for rent by owner homes in Luebbering.
Identify and perceive for rent by owner homes in Butler Missouri and homes for rent by owner.
Perceive and conceive Maysville United States vacation homes for rent by owner and Maysville United States homes for rent.
Find out and identify rental homes Osage and home rentals in Osage Missouri.
Disclose and relocate Maries Missouri vacation homes, Maries Missouri homes for rent, rent houses Maries, and Maries Missouri homes for rent by owner.
|
|
