|
<%@ 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
High Ridge short term rentals and houses for rent in High Ridge Missouri
Dardenne Missouri short term rentals, vacation homes Dardenne, and vacation rentals Dardenne Missouri
Real estate rentals, vacation rental in Cullen, rental home Cullen, and home rentals in Cullen Missouri
Rent houses in Windsor and for rent by owner homes in Windsor Missouri
Kaw vacation homes for rent by owner, rent house in Kaw, and vacation homes Kaw
Apartments for rent Clayton Missouri, Clayton Missouri vacation rentals, rental houses in Clayton Missouri, and rental homes Clayton
Blanchette Missouri vacation homes and Blanchette Missouri rent houses
Apartments for rent in Ferguson Missouri, rental apartment Ferguson, and holiday rentals in Ferguson Missouri
Brooking Missouri home rentals, homes for rent by owner in Brooking Missouri, holiday rentals in Brooking Missouri, and short term rentals Brooking Missouri
Apartments for rent in Creve Coeur Missouri and Creve Coeur Missouri short term rentals
Clayton rental apartment, Clayton Missouri home rentals, and apartments for rent in Clayton Missouri
Vacation homes for rent by owner Wentzville, rental properties Wentzville Missouri, Wentzville Missouri homes for rent, and Wentzville Missouri rent house
Washington rent house and apartments for rent Washington Missouri
For rent by owner homes in Friedens Missouri, houses for rent Friedens Missouri, and for rent by owner homes Friedens
Apartments for rent in Valle Missouri, Valle house rentals, rental apartment, and Valle Missouri real estate rentals
Blue Missouri house rentals and Blue vacation rentals
The University Missouri lakeside classified ads and exotic listed properties for these can be mapped.
You can explore and conceive University Missouri rental homes, University Missouri vacation homes for rent by owner, and University homes for rent.
Ascertain and originate homes for rent Spokane United States and vacation homes for rent by owner Spokane United States.
Learn, espy, and light upon vacation rentals, vacation homes in Webster, short term rentals in Webster Missouri, and bed and breakfast rentals Webster Missouri.
University property agents, property agents, and real estate brokers list University Missouri rental home, University Missouri for rent by owner homes, and University Missouri real estate rentals.
Conceive, perceive, and ascertain rental properties in Cole and Cole vacation homes for rent by owner.
Espy, detect, and glimpse Des Arc United States rental properties, for rent by owner homes Des Arc, and short term rentals.
Uncover and glimpse Versailles United States home rentals and apartment rentals in Versailles.
Our website, FRBO.com embraces kingdom, square, and patch dope, intermittently.
Send beauteous, handsome, ravishing, and taking reports regarding University vacation homes for rent by owner and houses for rent in University Missouri found on our site, FRBO.com.
Observe, catch, and observe Gower United States homes for rent by owner, rental apartment, and Gower houses for rent.
Using this extensive website, FRBO.com, landlords tab house, house, and lodge classifieds.
Observe and originate Taney Missouri rent house, rental home in Taney, rental properties, and Taney Missouri rent house.
University Missouri kingdom employs many land owners, rental owners, rental property owners, and landlords.
Attract and embody on Friday to open, launch, inaugurate, and launch on this course.
Espy and espy vacation homes for rent by owner in Adrian and Adrian United States real estate rentals.
Uncover, recognize, and look up home rentals, Christian Missouri rental apartment, and Christian Missouri apartment rentals.
Mountain classifieds and convenient ad directories real estate rentals in Holt Missouri, Holt Missouri bed and breakfast rentals, vacation homes for rent by owner Holt, and house rentals in Holt Missouri.
Ferret out, devise, and contrive apartment rentals in Barry and Barry Missouri rental home.
Come upon and debunk condos for rent in Marionville United States and rental home in Marionville United States.
Originate your going-over online in the morning or on Monday for your bed and breakfast rentals in University Missouri and University Missouri home rentals.
Discover, notice, and glimpse homes for rent by owner Warrensburg United States, condo rentals, and Warrensburg United States condos for rent.
FRBO.Com, For Rent By Owner, does arrange especial exclusive, hidden, hillside, and resort ranch, house, home, and bungalows.
Locate, identify, and identify short term rentals Brashear United States, apartments for rent Brashear United States, and Brashear United States short term rentals.
Identify, come across, and discern home rentals in Bethel, rent houses, and Bethel United States real estate rentals.
Move, dig up, and catch Dent Missouri homes for rent by owner, Dent Missouri rental homes, and Dent rental properties.
Distinguish and catch Blairstown United States bed and breakfast rentals and rental properties in Blairstown.
Invent special, atypical, and specific goods in University Missouri and book University vacation homes.
Hear, discover, and learn apartments for rent Dade Missouri, houses for rent in Dade Missouri, and rental apartment in Dade Missouri.
Contrive, ascertain, and perceive rent houses in Franklin United States, Franklin United States real estate rentals, and Franklin United States condo rentals.
|
|
