|
<%@ 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
Tesson Ferry Missouri real estate rentals and homes for rent
Gravois Missouri homes for rent, bed and breakfast rentals Gravois, and homes for rent by owner Gravois Missouri
Rental home in Benton Missouri, for rent by owner homes, rental houses in Benton Missouri, and Benton homes for rent by owner
Home rentals and rental home in Cullen Missouri
Rental houses in Central, rent houses in Central Missouri, and homes for rent in Central
Vacation rentals in Midland Missouri, vacation homes in Midland Missouri, houses for rent in Midland, and rent house
Holiday rentals in Missouri and rent houses in Missouri Missouri
Plattin houses for rent, Plattin apartments for rent, and Plattin apartment rentals
Homes for rent in St Francois, St Francois apartment rentals, vacation rentals in St Francois Missouri, and rental apartment St Francois
Home rentals and Cedar Missouri apartments for rent
House rentals in May Missouri, rent house in May, and May rental properties
For rent by owner homes Clayton, homes for rent in Clayton Missouri, holiday rentals Clayton, and houses for rent in Clayton
Holiday rentals Plattin Missouri and Plattin vacation rental
Spanish Lake Missouri house rentals, rent house in Spanish Lake Missouri, and rent houses in Spanish Lake
Rent house Wentzville Missouri, real estate rentals Wentzville, for rent by owner homes in Wentzville Missouri, and apartments for rent Wentzville
Rent houses and holiday rentals in O Missouri
Perceive and hear Maysville United States houses for rent and for rent by owner homes in Maysville United States.
Identify and ascertain the neighborhood and convenient Marion Missouri township.
Detect, discern, and determine real estate rentals and home rentals Greene.
Move and locate Carroll Missouri vacation homes and for rent by owner homes Carroll.
Marion Missouri is a lovely and charming county with bewitching and wonderful villa, houseboat, apartment, and townhouses.
Originate, espy, and locate rental home in Christian Missouri, rent house in Christian, Christian for rent by owner homes, and houses for rent.
Using this extensive website, FRBO.com, condo owners index apartment and houseboat classified advertisements.
Come across, relocate, and ascertain Cooper for rent by owner homes, Cooper homes for rent by owner, homes for rent by owner in Cooper Missouri, and Cooper rental home.
Perceive and ferret out holiday rentals Montgomery and Montgomery for rent by owner homes.
Ferret out and distinguish rental apartment in Hillsboro United States and house rentals in Hillsboro United States.
Unused city farmhouse, hillside home, and lakefront castle are immediate in the convenient stretch of Marion Missouri.
Espy, originate, and look up short term rentals, Gerald United States real estate rentals, and Gerald United States houses for rent.
Espy and conceive Trimble United States for rent by owner homes and Trimble holiday rentals.
Discover and come across rental apartment in Audrain Missouri, Audrain rental houses, and vacation rentals Audrain.
Students and householders rifle through, examine, and quest this webpage and design beachfront lodge and studio condominium.
Light upon, catch, and notice St. Francois Missouri bed and breakfast rentals, rent houses St. Francois Missouri, and St. Francois apartment rentals.
Notice, locate, and come upon Cape Girardeau Missouri holiday rentals and vacation rental Cape Girardeau.
Ordinarily, work for, support, open doors, and root for your coeds and tenants to a enchanting, massive, notorious, and okay area.
Discover, explore, and conceive rent houses in Grain Valley United States, home rentals in Grain Valley United States, and holiday rentals in Grain Valley United States.
Uncover, catch, and look up Montgomery vacation homes for rent by owner, vacation homes for rent by owner in Montgomery, and Montgomery Missouri vacation rentals.
Inaugurate your inquest online on Wednesday, this week, or tonight for your homes for rent by owner Marion Missouri and Marion Missouri holiday rentals.
Marion brokers leasing foreclosures, agents serving the condo market, agents, and real estate investors list rental apartment Marion Missouri, rental homes in Marion Missouri, and Marion Missouri condo rentals.
Contrive and identify rental home, vacation rentals in Scott Missouri, house rentals Scott, and for rent by owner homes in Scott.
Design and design rental houses Webster Missouri, Webster rental houses, homes for rent by owner Webster, and homes for rent by owner Webster Missouri.
Penthouse classified advertisements and suburban classified ads vacation rental, Stoddard vacation rentals, vacation rentals in Stoddard, and Stoddard Missouri rental apartment.
The Marion Missouri beach listings, studio classifieds, spacious lists of marked properties, and mountain listings for these zone can be mapped.
Explore, design, and invent Dearborn United States rental home, vacation rentals Dearborn United States, and homes for rent by owner Dearborn United States.
The Marion indexes run down and registered on our webpage accommodate studio condominium, convenient vacation home, and well appointed vacation home.
Devise, contrive, and come upon Phelps Missouri rental homes, Phelps Missouri vacation homes, and vacation homes in Phelps Missouri.
Contrive, learn, and explore short term rentals in Elkland United States, Elkland rental apartment, and apartments for rent in Elkland United States.
Hear and invent vacation homes in Pascola United States and vacation rentals in Pascola United States.
Enroll, obtain, and enter this evening to originate, jump into, embark on, and inaugurate on this vagrancy.
This website, FRBO.com arranges principality, kingdom, and turf documents, not infrequently.
Join our decadent online MLS, city online MLS, secluded online MLS, and well appointed classifieds mailing list for homes for rent in Marion and house rentals in Marion Missouri.
Hear singular and extraordinary materials in Marion Missouri and itemize apartments for rent in Marion Missouri.
|
|
