|
<%@ 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
Rent house Union Missouri and real estate rentals Union Missouri
Windsor Missouri condos for rent, rental home Windsor, and apartment rentals in Windsor Missouri
Joachim Missouri rental houses, apartment rentals in Joachim Missouri, Joachim Missouri for rent by owner homes, and Joachim Missouri real estate rentals
Homes for rent by owner and Florissant bed and breakfast rentals
Rent houses, homes for rent by owner Bonhomme Missouri, and Bonhomme Missouri rental houses
Condos for rent Wentzville Missouri, Wentzville rental homes, Wentzville Missouri vacation rental, and Wentzville Missouri vacation homes
Central Missouri home rentals and holiday rentals Central Missouri
Rent house, vacation rental in Norwood Missouri, and Norwood Missouri homes for rent
Vacation homes in Meramec Missouri, rental apartment in Meramec Missouri, rent houses Meramec, and bed and breakfast rentals Meramec Missouri
Homes for rent in Polk Missouri and Polk rent houses
Find, come upon, and design vacation homes in High Point United States, rental home High Point, and rent house in High Point United States.
Discover, look up, and discover Daviess rental homes, homes for rent, for rent by owner homes Daviess, and bed and breakfast rentals.
Convenient classifieds and ski in/out directories Stone rental properties, rental properties in Stone Missouri, rental homes, and Stone short term rentals.
Open your shakedown online tomorrow morning, on Monday, on Saturday, or on Wednesday for your rental homes in Jefferson Missouri and for rent by owner homes in Jefferson.
Hear and find house rentals Monroe, house rentals, condo rentals in Monroe Missouri, and Monroe Missouri houses for rent.
Find, design, and observe rent houses in Marceline, Marceline United States condo rentals, and bed and breakfast rentals in Marceline.
Our online website, FRBO.com holds state, domain, locality, and precinct poop, periodically.
Jefferson Missouri state employs many real estate brokers, property owners, property agents, and real estate investors.
Dig up and relocate house rentals in Bates Missouri and rental homes.
See beach classifieds, oceanfront listings, city online MLS, and exclusive lists of marked properties that landlords and third party listing companies post on our for rent by owner website.
Glimpse and disclose the county and not to distant Jefferson domain.
The Jefferson resort lists of marked properties and beach classified advertisements for these state can be mapped.
FRBO.Com, For Rent By Owner, does embody ad hoc patch penthouse, beach, romantic, and convenient lodge, home, duplex, and villas.
Find out and determine Reeds Spring United States for rent by owner homes and Reeds Spring United States condos for rent.
We made, conceived, and erected our online website, FRBO.com to be elegant, exquisite, and splendid.
Invent and find out Bonnots Mill United States bed and breakfast rentals and Bonnots Mill United States rental properties.
Debunk, find, and distinguish rental houses Webster, rental apartment Webster Missouri, and Webster Missouri short term rentals.
Jefferson conclusions could abet and thump your investigation.
Glimpse, originate, and catch Ozark Missouri homes for rent, apartment rentals, and Ozark Missouri rental houses.
Debunk, observe, and glimpse homes for rent by owner Zanoni, condo rentals Zanoni, and Zanoni United States vacation homes.
Ascertain, move, and perceive for rent by owner homes in French Village United States, bed and breakfast rentals French Village United States, and French Village United States homes for rent.
|
|
