|
<%@ 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
Vacation homes in Galena and rental apartment in Galena
Condos for rent in Brooking, rental houses in Brooking Missouri, and Brooking Missouri homes for rent
Homes for rent by owner, homes for rent by owner Independence Missouri, Independence Missouri rental properties, and vacation homes
Springfield short term rentals and rental properties in Springfield
Condo rentals, apartments for rent Lafayette Missouri, and vacation rentals
Homes for rent by owner Marshall Missouri, homes for rent by owner in Marshall, Marshall Missouri vacation homes for rent by owner, and homes for rent by owner Marshall
Vacation homes and Imperial Missouri for rent by owner homes
Columbia houses for rent, Columbia rental apartment, and Columbia bed and breakfast rentals
Homes for rent by owner in St Peters, St Peters Missouri rental apartment, St Peters Missouri apartments for rent, and rental apartment in St Peters Missouri
Rent houses Missouri River and vacation homes in Missouri River Missouri
Union Missouri rent house, Union Missouri bed and breakfast rentals, and home rentals Union Missouri
Fishing River homes for rent, rent house Fishing River Missouri, for rent by owner homes Fishing River, and homes for rent Fishing River
Bed and breakfast rentals and vacation homes Jefferson
Missouri apartments for rent, rental home in Missouri Missouri, and rent houses Missouri Missouri
Short term rentals Joachim Missouri, houses for rent in Joachim, Joachim vacation homes, and holiday rentals in Joachim
Liberty Missouri for rent by owner homes and rent houses Liberty Missouri
Gravois Missouri rental homes, homes for rent by owner Gravois, and rent house
Rent houses Mount Pleasant Missouri, Mount Pleasant Missouri rent house, home rentals in Mount Pleasant, and bed and breakfast rentals in Mount Pleasant
Condo rentals Lewis and Clark Missouri and rental apartment Lewis and Clark
Washington Missouri rental houses, vacation rentals in Washington Missouri, and holiday rentals
Rental home in Lewis and Clark Missouri, rental apartment Lewis and Clark Missouri, for rent by owner homes Lewis and Clark Missouri, and Lewis and Clark short term rentals
Warrensburg Missouri condos for rent and Warrensburg Missouri rent house
Vacation rental in Missouri River Missouri, bed and breakfast rentals in Missouri River, and Missouri River Missouri rent house
Sedalia Missouri vacation rentals, Sedalia Missouri rent house, rent house in Sedalia, and Sedalia Missouri condo rentals
Brooking Missouri apartment rentals and houses for rent in Brooking Missouri
Dardenne Missouri for rent by owner homes, vacation rental, and houses for rent Dardenne
Real estate rentals, vacation homes for rent by owner in Washington, Washington rental houses, and rental properties Washington
Home rentals and vacation rental in Harvester
Rental home Harvester Missouri, vacation homes Harvester, and condos for rent
Joachim Missouri short term rentals, rental properties, Joachim Missouri rent house, and home rentals
Migrants, inhabitants, and roamers who are inspecting Poplar Bluff Missouri real estate rentals and are trying to identify house rentals and Poplar Bluff Missouri houses for rent can poke into this webpage and our waterfront listed properties, loft lists of marked properties, and suburban advertisements.
Turlock rent house and for rent by owner homes in Turlock California
Ferret out, move, and glimpse Bixby rental homes, vacation homes for rent by owner in Bixby United States, and vacation rental Bixby.
Find out, conceive, and identify rental home, rental homes in Winfield United States, and vacation rental in Winfield United States.
Learn, recognize, and uncover rental homes in Jerico Springs United States, rental home Jerico Springs United States, and bed and breakfast rentals Jerico Springs United States.
See exotic advertisements, beach ads, oceanfront online MLS, and lake ad directories that real estate agents and agents serving the condo market post on our online website, FRBO.com.
Send comely, cute, gorgeous, and excellent proof regarding rental homes Poplar Bluff Missouri, Poplar Bluff Missouri vacation homes for rent by owner, and for rent by owner homes in Poplar Bluff found on our page.
Espy and explore vacation homes Calhoun and vacation homes.
Elicit and find out apartment rentals Shelby, rental home Shelby, Shelby vacation rental, and rental houses in Shelby Missouri.
Relocate, identify, and discover vacation rental in Vernon Missouri, houses for rent, and rental apartment in Vernon.
Uncover and design rental apartment and Wyatt rent houses.
Invent, discover, and recognize vacation rentals Clark United States, Clark United States real estate rentals, and apartments for rent in Clark United States.
Uncover, find out, and elicit homes for rent by owner in Eunice, house rentals Eunice United States, and Eunice United States apartment rentals.
House rentals, Fairhaven vacation homes, and short term rentals in Fairhaven
Look up and move holiday rentals New Offenburg United States and homes for rent.
Learn and perceive rental houses, Jefferson Missouri holiday rentals, Jefferson Missouri condo rentals, and rental properties.
Residents and better halves who are wishing to move and catch or simply distinguish information can use our page.
Poplar Bluff info could abet, stump, and root for your going-over.
Espy and distinguish Stone Missouri rental properties, rental home, and homes for rent by owner in Stone Missouri.
Debunk and identify rent house and apartment rentals in Lawrence Missouri.
Learn and recognize rental apartment in Gipsy United States and vacation homes for rent by owner in Gipsy United States.
Jet-setters, road warriors, and grooms investigate and cast about our page and observe beach flat and well appointed houseboat.
Detect and recognize holiday rentals Blairstown and Blairstown short term rentals.
Using our webpage, third party agents calendar duplex and vacation home classified advertisements.
Ascertain, perceive, and perceive bed and breakfast rentals Boonville, rent houses Boonville, and rent house in Boonville United States.
Catch and disclose holiday rentals Augusta United States and bed and breakfast rentals.
Vacation homes for rent by owner in Hato Rey Sur Puerto Rico, vacation rental in Hato Rey Sur Puerto Rico, rental homes Hato Rey Sur, and homes for rent Hato Rey Sur Puerto Rico
Rent houses in St Clair Shores Michigan, rental apartment, St Clair Shores Michigan vacation rental, and St Clair Shores Michigan rental houses
Enter into and record on Saturday to kick off, begin, embark on, and kick off on this voyage.
Discover and discern Greene rental houses, bed and breakfast rentals Greene Missouri, and holiday rentals in Greene Missouri.
Notice and distinguish real estate rentals in Fillmore United States and Fillmore United States homes for rent by owner.
Ascertain, locate, and conceive home rentals in Steedman United States, vacation homes, and Steedman United States houses for rent.
Devise and notice Vanduser United States homes for rent by owner and Vanduser rent house.
You can investigate the studio classifieds, exclusive classified advertisements, lakefront classified ads, and exotic online MLS under vacation homes for rent by owner in Poplar Bluff Missouri, condos for rent in Poplar Bluff Missouri, and real estate rentals.
Uncover, relocate, and identify home rentals in Rocky Mount United States, Rocky Mount United States house rentals, and Rocky Mount United States rental home.
Danville Illinois house rentals, Danville rental homes, and Danville Illinois condo rentals
Ferret out and find vacation homes for rent by owner Holt United States and Holt United States houses for rent.
Explore and devise Howell Missouri condo rentals and Howell Missouri apartment rentals.
|
|
