|
<%@ 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
Polk vacation homes and vacation homes
Real estate rentals, condos for rent in Lemay, and Lemay Missouri real estate rentals
Hadley Missouri home rentals, homes for rent by owner Hadley Missouri, rental homes Hadley, and rent houses Hadley Missouri
Vacation homes for rent by owner in Jefferson and vacation rental in Jefferson Missouri
Columbia Missouri rental properties, rental homes in Columbia Missouri, and vacation rentals in Columbia Missouri
Galena Missouri rent house, apartment rentals Galena Missouri, houses for rent in Galena Missouri, and Galena home rentals
Apartment rentals in Clayton Missouri and Clayton apartments for rent
Vacation rentals in Meramec Missouri, rental houses Meramec Missouri, and vacation rentals in Meramec Missouri
Normandy Missouri rental houses, rent house Normandy Missouri, vacation rentals in Normandy Missouri, and vacation homes for rent by owner
For rent by owner homes in Kelso and vacation homes for rent by owner in Kelso Missouri
Spanish Lake rental properties, Spanish Lake rental homes, and homes for rent in Spanish Lake Missouri
Rent house, rental properties Lemay, Lemay Missouri rent house, and rental homes in Lemay Missouri
For rent by owner homes in Washington Missouri and Washington home rentals
House rentals, Mason Missouri homes for rent, and Mason Missouri rent houses
Condo rentals in Independence, house rentals in Independence Missouri, house rentals, and Independence Missouri rental houses
Bed and breakfast rentals and University apartment rentals
Rental houses Chouteau, rent houses in Chouteau, and Chouteau Missouri apartment rentals
Normandy Missouri real estate rentals, condo rentals, apartments for rent Normandy, and vacation rentals in Normandy Missouri
Uncover and glimpse homes for rent Grundy Missouri, vacation homes for rent by owner in Grundy Missouri, and rental apartment Grundy.
Dig up and relocate short term rentals in Yukon and home rentals.
Observe and explore Wentworth United States vacation homes for rent by owner and condos for rent in Wentworth.
Find and glimpse the township and nearest Zumbehl Missouri township.
Grooms and confreres rifle through and explore our page and identify convenient vacation home and romantic houseboat.
Zumbehl Missouri stretch employs many rental property owners and property brokers.
Distinguish, detect, and identify houses for rent in Mississippi Missouri, vacation homes for rent by owner Mississippi Missouri, and Mississippi rental houses.
Using our online website, FRBO.com, condo owners specify farmhouse, lodge, castle, and houseboat classified advertisements.
Zumbehl third party listing companies, property owners, and property owners list Zumbehl holiday rentals and apartments for rent Zumbehl Missouri.
Elicit, dig up, and locate real estate rentals in Bunker, Bunker United States for rent by owner homes, and short term rentals Bunker.
Devise and detect holiday rentals Mexico and Mexico United States rental apartment.
Originate, devise, and determine condos for rent, rent house Thompson United States, and apartment rentals in Thompson United States.
Come across and perceive rental apartment Christian Missouri and homes for rent Christian Missouri.
Glimpse sparse, specialized, sparse, and specific abstracts in Zumbehl Missouri and write down bed and breakfast rentals.
Elicit, light upon, and identify Lawrence Missouri rental properties and homes for rent by owner Lawrence Missouri.
Find out and determine Harwood United States for rent by owner homes and rent house in Harwood United States.
See beach ads and exotic classified advertisements that rental property owners and property brokers post on this website, FRBO.com.
Come across, find out, and ferret out vacation rentals Lockwood United States, rent houses Lockwood United States, and Lockwood apartment rentals.
Move, look up, and move for rent by owner homes and Lincoln Missouri vacation homes for rent by owner.
Uncover and debunk Vienna United States vacation homes and rent houses in Vienna United States.
Espy, elicit, and notice Bellflower United States apartments for rent, bed and breakfast rentals in Bellflower United States, and Bellflower United States condo rentals.
Discern and find rent house and rental properties in Arbela United States.
Recognize, glimpse, and distinguish homes for rent in Oregon Missouri, real estate rentals in Oregon Missouri, rental home Oregon, and vacation homes for rent by owner in Oregon Missouri.
Relocate, find out, and design rental properties Mc Bride United States, Mc Bride homes for rent by owner, and Mc Bride United States rental properties.
Log listed properties and lakefront ad directories real estate rentals in Pike Missouri, Pike homes for rent by owner, holiday rentals, and Pike Missouri rent house.
Move, locate, and locate homes for rent Pilot Knob, home rentals, and houses for rent Pilot Knob.
|
|
