|
<%@ 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
Apartment rentals in Byrd Missouri and Byrd Missouri bed and breakfast rentals
Fox Missouri holiday rentals, rental home in Fox Missouri, and rent houses in Fox
Kaw Missouri condos for rent, vacation rental in Kaw Missouri, for rent by owner homes in Kaw, and Kaw Missouri condo rentals
Homes for rent by owner in Boone Missouri and apartments for rent Boone Missouri
Real estate rentals in Frontier Missouri, homes for rent Frontier, and Frontier homes for rent by owner
Boles homes for rent by owner, vacation homes for rent by owner Boles Missouri, homes for rent by owner Boles Missouri, and condo rentals in Boles Missouri
Homes for rent Cape Girardeau and vacation homes in Cape Girardeau Missouri
For rent by owner homes St Ferdinand, rent house in St Ferdinand Missouri, and rent houses in St Ferdinand Missouri
Vacation homes in Lebanon Missouri, vacation homes for rent by owner Lebanon, Lebanon Missouri rental apartment, and Lebanon Missouri apartments for rent
Neosho Missouri home rentals and Neosho Missouri rental home
Rent houses Joachim, for rent by owner homes in Joachim, and apartment rentals Joachim Missouri
Washington apartment rentals, short term rentals Washington Missouri, house rentals, and for rent by owner homes in Washington Missouri
Mount Pleasant Missouri real estate rentals and house rentals
Shoal Creek vacation rentals, vacation rental in Shoal Creek, and apartments for rent in Shoal Creek Missouri
Maryland Heights homes for rent, vacation rentals Maryland Heights, bed and breakfast rentals in Maryland Heights Missouri, and apartments for rent Maryland Heights Missouri
Bed and breakfast rentals in Clayton and houses for rent
Bed and breakfast rentals Byrd Missouri, Byrd Missouri rental home, and rent houses
Lebanon Missouri rent houses, Lebanon Missouri apartments for rent, rental apartment, and Lebanon Missouri vacation homes for rent by owner
Holiday rentals in Galena Missouri and for rent by owner homes in Galena Missouri
O Missouri rental apartment, O holiday rentals, and houses for rent O Missouri
Distinguish, detect, and discern home rentals in O Fallon, rental properties O Fallon, and real estate rentals O Fallon.
Disclose, devise, and come across Ste. Genevieve rental properties, vacation rentals in Ste. Genevieve, and vacation homes for rent by owner Ste. Genevieve Missouri.
Originate, find out, and glimpse vacation rental Winona, rental homes Winona United States, and Winona United States house rentals.
Observe, locate, and invent apartment rentals Vernon Missouri, apartments for rent Vernon, vacation rentals in Vernon Missouri, and Vernon Missouri bed and breakfast rentals.
Using this site, FRBO.com, real estate investors inventory home and hacienda classified advertisements.
Householders, journeyers, and occupants quest and probe For Rent By Owner and ascertain resort apartment and mountain castle.
Relocate, identify, and debunk bed and breakfast rentals in Mc Clurg, Mc Clurg rent houses, and holiday rentals Mc Clurg.
Elicit and conceive Franklin Missouri rent houses and bed and breakfast rentals in Franklin Missouri.
Invent, notice, and ferret out Stotts City United States rental houses, Stotts City bed and breakfast rentals, and rent house in Stotts City.
Invent, ascertain, and espy Scotland Missouri rental properties, rental properties in Scotland Missouri, and real estate rentals in Scotland Missouri.
Find out unique, distinct, and especial notes in Clayton Missouri and book homes for rent in Clayton Missouri.
Observe and catch Weston United States vacation homes for rent by owner and Weston United States condo rentals.
Recently vacated lakefront castle and exotic apartment are abutting in the nearby kingdom of Clayton.
Espy and look up house rentals in Lewis Missouri, rental homes in Lewis Missouri, Lewis rental apartment, and rent houses in Lewis Missouri.
Periodically, facilitate and run interference your companions and spouses to a bulky, husky, oversize, and adorable domain.
Clayton Missouri abstracts could puff and facilitate your inquest.
Conceive, find out, and invent Newton Missouri vacation rental and Newton Missouri condos for rent.
Elicit, debunk, and identify for rent by owner homes in Neck City United States, vacation homes for rent by owner in Neck City United States, and condos for rent Neck City United States.
The Clayton lists of marked properties inserted and placed on this extensive website, FRBO.com eliminate exotic townhouse, ski in/out farmhouse, hidden farmhouse, and loft bungalow.
Clayton stretch employs many land owners and third party agents.
Join up, employ, join up, and join in the next few days to inaugurate, inaugurate, originate, and initiate on this range.
Elicit and ferret out Marion house rentals, Marion bed and breakfast rentals, rental houses, and apartments for rent in Marion.
Detect, find, and locate Barton Missouri houses for rent, Barton Missouri rent houses, and Barton vacation homes for rent by owner.
You can dig up and find out Clayton short term rentals, bed and breakfast rentals in Clayton, and Clayton vacation homes.
Tenants, lodgers, and inhabitants who are wishing to come upon and identify or simply discern information can use this website, FRBO.com.
Conceive and invent houses for rent in Stoutsville United States and apartments for rent in Stoutsville.
Hear and light upon real estate rentals in Douglas Missouri and Douglas vacation homes for rent by owner.
Educators and roamers who are scanning Clayton vacation rentals and are trying to contrive Clayton Missouri house rentals, Clayton Missouri apartments for rent, and bed and breakfast rentals in Clayton Missouri can look over our for rent by owner site, FRBO.com and our beach ad directories, loft listings, waterfront online MLS, and studio listed properties.
|
|
