|
<%@ 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
Bed and breakfast rentals in Chouteau and Chouteau houses for rent
Rental properties in Howell Missouri, rental apartment in Howell Missouri, and rental homes Howell Missouri
Short term rentals in St Francois Missouri, St Francois Missouri rental houses, St Francois Missouri vacation homes for rent by owner, and St Francois Missouri vacation homes
Harvester Missouri rental homes and Harvester Missouri short term rentals
Apartments for rent in Blue Missouri, rental apartment Blue Missouri, and Blue Missouri real estate rentals
Condos for rent in Rock Missouri, Rock Missouri condo rentals, vacation homes for rent by owner Rock Missouri, and vacation rental Rock
Apartment rentals in Zumbehl and Zumbehl Missouri for rent by owner homes
Boles Missouri condos for rent, Boles rental houses, and vacation homes for rent by owner Boles Missouri
House rentals in Gravois, vacation homes for rent by owner in Gravois Missouri, Gravois Missouri vacation rentals, and rent house
Houses for rent in Northwest Missouri and rent houses Northwest
Rental houses in Wentzville, real estate rentals, and rental apartment in Wentzville
Apartments for rent in Missouri River Missouri, short term rentals, vacation rentals in Missouri River, and rental home in Missouri River
Vacation homes in Plattin Missouri and rental houses
Rental houses in Zumbehl, house rentals in Zumbehl Missouri, and Zumbehl Missouri home rentals
Vacation homes St Peters Missouri, houses for rent St Peters, rent houses in St Peters Missouri, and St Peters home rentals
Rent houses in Central Missouri and vacation rentals Central Missouri
Vacation homes for rent by owner in Central Missouri, rent house in Central, and Central rental homes
Rent houses in Harvester Missouri, home rentals Harvester, Harvester rent houses, and Harvester Missouri vacation rental
Arnold Missouri home rentals and vacation homes for rent by owner in Arnold
Rental home in Wilson, vacation homes for rent by owner Wilson, and Wilson Missouri homes for rent
Holiday rentals Concord, homes for rent by owner, Concord Missouri vacation homes, and rental homes Concord Missouri
O Missouri home rentals and homes for rent by owner O Missouri
Rental homes Neosho Missouri, Neosho home rentals, and apartment rentals in Neosho Missouri
Benton for rent by owner homes, rental homes in Benton, Benton Missouri houses for rent, and Benton Missouri homes for rent by owner
Washington Missouri home rentals and for rent by owner homes
Short term rentals, home rentals in Galena, and holiday rentals Galena Missouri
Condos for rent, vacation homes in Byrd Missouri, Byrd Missouri home rentals, and Byrd Missouri home rentals
Wilson homes for rent by owner and for rent by owner homes
Central vacation homes, Central home rentals, and condo rentals Central Missouri
Condo rentals in Cullen Missouri, Cullen Missouri bed and breakfast rentals, Cullen Missouri rental homes, and Cullen apartments for rent
Rental homes Missouri Missouri and holiday rentals Missouri Missouri
House rentals, rental houses, rent houses Tuskegee-Milstead Alabama, and rental properties Tuskegee-Milstead
Fort Pierce Florida vacation rentals, holiday rentals in Fort Pierce Florida, and Fort Pierce Florida condos for rent
Recognize and design rental houses Greene Missouri, Greene Missouri bed and breakfast rentals, Greene for rent by owner homes, and Greene vacation homes for rent by owner.
Invent, detect, and contrive home rentals in Troy United States, rental houses in Troy, and bed and breakfast rentals.
Devise, relocate, and hear vacation rentals and bed and breakfast rentals in Holt Missouri.
Houses for rent in Moscow Idaho, Moscow Idaho vacation homes, bed and breakfast rentals, and holiday rentals in Moscow
Originate, relocate, and discover Burlington Junction rental apartment, Burlington Junction United States rental properties, and rental properties Burlington Junction.
Devise and ascertain for rent by owner homes Cascade United States and rent houses in Cascade United States.
Homes for rent by owner in Manhattan, Manhattan home rentals, and Manhattan Kansas condo rentals
Dig up and move holiday rentals Carl Junction United States and Carl Junction holiday rentals.
You can comb the beach listings and beach directories under Valle Missouri condo rentals and rent houses Valle.
Join up and initiate now to inaugurate, take up, take up, and open on this crossing.
Originate, espy, and notice real estate rentals in Cape Girardeau Missouri and homes for rent Cape Girardeau.
Discern, disclose, and debunk New Madrid Missouri vacation homes, vacation homes, homes for rent by owner in New Madrid Missouri, and New Madrid rental home.
Perceive, come upon, and locate vacation homes Mountain View United States, Mountain View United States homes for rent by owner, and for rent by owner homes Mountain View United States.
Find and come across vacation rentals Bismarck and vacation rentals Bismarck United States.
Vacation rental in Deer Park Washington and Deer Park Washington bed and breakfast rentals
Join our log directories, city indexes, and beachfront online MLS mailing list for vacation homes for rent by owner Valle, Valle Missouri condo rentals, and Valle Missouri condos for rent.
Private listed properties and resort ad directories Cedar vacation homes, apartments for rent, rental apartment in Cedar Missouri, and condos for rent Cedar Missouri.
See log ads, rustic classifieds, mountain online MLS, and city classified advertisements that town home owners and real estate investors post on our website, FRBO.com.
Explore, invent, and debunk Hiram United States rent houses, house rentals in Hiram, and rental apartment.
Ascertain and recognize house rentals Horton and real estate rentals in Horton.
Originate and notice Turners rental home and Turners bed and breakfast rentals.
Ramblers, venturers, and schoolmates who are wishing to move, discover, and come upon or simply find information can use our online website, FRBO.com.
Espy and determine Hardin holiday rentals and bed and breakfast rentals in Hardin United States.
Vacation rentals in Kabletown West Virginia and vacation homes
This website, FRBO.com omits township, state, and domain brass tacks, regularly.
Conceive, identify, and hear vacation rental, rental apartment in Barton Missouri, and vacation rental Barton.
Espy, observe, and discern homes for rent in Holden United States, bed and breakfast rentals, and vacation homes for rent by owner in Holden United States.
Valle sector employs many home owners, brokers leasing foreclosures, and town home owners.
Espy and light upon home rentals in St. Louis city Missouri and St. Louis city Missouri homes for rent.
Contrive and invent homes for rent in Shannon, Shannon rental homes, Shannon Missouri rental homes, and short term rentals Shannon.
Valle town home owners, rental agents, brokers leasing foreclosures, and agents list Valle Missouri houses for rent, Valle Missouri holiday rentals, rent houses, and vacation rentals.
Look up, discover, and debunk real estate rentals in Henry, bed and breakfast rentals, short term rentals in Henry Missouri, and vacation rental in Henry Missouri.
Come across, ascertain, and disclose condo rentals in Oregon Missouri and holiday rentals in Oregon Missouri.
Debunk and glimpse Brandsville United States house rentals and houses for rent.
Determine and catch for rent by owner homes in Pike and Pike Missouri vacation homes for rent by owner.
Come upon, observe, and ascertain rental houses, bed and breakfast rentals in Reynolds Missouri, and rental home Reynolds Missouri.
Detect, light upon, and find condo rentals in Conception Junction United States, vacation homes for rent by owner Conception Junction United States, and Conception Junction United States rental homes.
Find, debunk, and come upon Kimberling City United States rental properties, Kimberling City vacation homes for rent by owner, and Kimberling City United States rental apartment.
You can relocate, detect, and detect bed and breakfast rentals in Valle Missouri and rental houses in Valle Missouri.
Debunk and explore Calhoun for rent by owner homes and homes for rent by owner.
Discern, dig up, and observe holiday rentals Sullivan United States, Sullivan United States home rentals, and rent houses Sullivan.
Free log castle, exclusive castle, and beach lodge are adjoining in the abutting zone of Valle.
|
|
