|
<%@ 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 houses in Frontier Missouri and rental properties
Benton rent houses, rental apartment Benton, and rental apartment Benton
For rent by owner homes in Prairie, vacation rental in Prairie Missouri, Prairie rental properties, and apartment rentals
Queeny holiday rentals and rental home
Homes for rent by owner, rental apartment, and real estate rentals in Marshall Missouri
For rent by owner homes in Harvester Missouri, Harvester Missouri rental home, apartment rentals in Harvester Missouri, and apartment rentals in Harvester Missouri
Maryland Heights bed and breakfast rentals and condos for rent in Maryland Heights
Airport real estate rentals, rental homes in Airport Missouri, and Airport house rentals
Washington Missouri rental houses, Washington Missouri homes for rent, vacation homes for rent by owner in Washington Missouri, and Washington Missouri short term rentals
Apartment rentals in Warrensburg and Warrensburg Missouri houses for rent
Lemay vacation homes, rental home Lemay Missouri, and Lemay Missouri vacation rentals
Rental homes Maryland Heights Missouri, rent houses in Maryland Heights, rent houses Maryland Heights, and Maryland Heights Missouri rent house
Condos for rent in Friedens Missouri and vacation rental in Friedens
House rentals in Washington, Washington Missouri house rentals, and Washington Missouri rental properties
Home rentals Poplar Bluff, rental properties Poplar Bluff Missouri, Poplar Bluff Missouri vacation homes, and home rentals Poplar Bluff Missouri
St Francois Missouri rental homes and homes for rent
Vacation rental Fishing River Missouri, Fishing River Missouri rental home, and short term rentals Fishing River Missouri
Real estate rentals, Wilson for rent by owner homes, rental homes in Wilson Missouri, and Wilson Missouri vacation homes for rent by owner
Rent houses and vacation rental in Sedalia Missouri
Vacation homes for rent by owner Imperial Missouri, vacation homes for rent by owner, and Imperial rent house
Look up, distinguish, and recognize apartments for rent Vernon and rental home.
Originate and espy condo rentals in Maries Missouri and houses for rent in Maries Missouri.
Ofttimes, bail out, work for, boost, and help your transmigrants and trippers to a stunning, beautiful, and vast vicinity.
Vacant secluded flat, oceanfront hacienda, lakeside farmhouse, and lakefront houseboat are not to distant in the nearest sector of Hadley.
Determine and detect Grassy United States rental houses and for rent by owner homes Grassy United States.
You can locate and relocate houses for rent Hadley Missouri and holiday rentals in Hadley.
Ferret out, glimpse, and ferret out rental apartment in Ellington, bed and breakfast rentals in Ellington United States, and bed and breakfast rentals in Ellington United States.
Distinguish and identify Breckenridge United States vacation rentals and Breckenridge United States apartments for rent.
See private ad directories and private ads that third party listing companies and land owners post on this site, FRBO.com.
Locate, identify, and locate Neck City United States apartment rentals, rental houses, and Neck City United States home rentals.
Elicit, determine, and glimpse Scott Missouri apartment rentals and rental homes Scott.
Using our for rent by owner website, agents serving the condo market run down ranch and apartment classified advertisements.
Take up your inquiry online tonight, tomorrow morning, in the next few days, or on Sunday for your rental home in Hadley Missouri, Hadley Missouri house rentals, and homes for rent by owner in Hadley Missouri.
Traveling saleswomen and traveling saleswomen grub and scout our online website, FRBO.com and discern lakefront chalet, lakefront hacienda, well appointed home, and exclusive bungalow.
Discover and debunk real estate rentals and for rent by owner homes Buffalo United States.
Elicit, discover, and uncover holiday rentals Worth, rental houses in Worth, vacation rentals Worth Missouri, and rental apartment Worth Missouri.
You can quest the decadent ad directories, convenient lists of marked properties, lakefront advertisements, and secluded classified advertisements under Hadley Missouri house rentals and Hadley Missouri rent houses.
Recognize and uncover Paris rental home and Paris United States vacation homes.
We invested and erected this site, For Rent By Owner (FRBO.com) to be exquisite, refined, and alluring.
Come upon, espy, and ascertain Louisiana bed and breakfast rentals, Louisiana United States house rentals, and Louisiana United States bed and breakfast rentals.
Explore and discern rental home Marion Missouri and rent houses in Marion.
Originate and find out vacation homes for rent by owner St. Clair and vacation rentals St. Clair Missouri.
Locate, detect, and glimpse short term rentals in Leeton United States, rental home Leeton, and rent house in Leeton.
Exclusive ads and beach listings rental houses in Douglas Missouri, Douglas vacation rental, Douglas Missouri rental apartment, and home rentals in Douglas Missouri.
|
|
