|
<%@ 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
Rental properties Jefferson and vacation rental Jefferson Missouri
Blanchette apartment rentals, vacation homes for rent by owner Blanchette, and apartment rentals in Blanchette Missouri
Rental homes in Byrd Missouri, bed and breakfast rentals in Byrd Missouri, home rentals Byrd Missouri, and Byrd Missouri real estate rentals
Homes for rent by owner in Imperial and Imperial Missouri rental home
Sni-A-Bar Missouri real estate rentals, real estate rentals, and rental houses Sni-A-Bar
Apartments for rent in River View, River View for rent by owner homes, vacation homes for rent by owner River View Missouri, and homes for rent in River View Missouri
Vacation homes in Cape Girardeau and Cape Girardeau Missouri for rent by owner homes
Rent house in Lebanon Missouri, apartment rentals, and rental homes Lebanon Missouri
Bonhomme Missouri home rentals, home rentals in Bonhomme Missouri, houses for rent in Bonhomme Missouri, and homes for rent Bonhomme Missouri
Home rentals in Blue and vacation homes Blue
Grand River apartments for rent, bed and breakfast rentals in Grand River Missouri, and rental apartment in Grand River Missouri
Houses for rent Queeny Missouri, Queeny Missouri bed and breakfast rentals, house rentals in Queeny Missouri, and rent house Queeny
Wilson Missouri houses for rent and house rentals
For rent by owner homes in Carroll Missouri, rental houses in Carroll Missouri, and homes for rent
Short term rentals in University, University condo rentals, rent house, and vacation rental
Rental home Northwest and Northwest bed and breakfast rentals
Kearney rental apartment, home rentals Kearney, and rental properties
Rental houses in Washington, Washington Missouri apartments for rent, Washington condos for rent, and apartments for rent in Washington Missouri
Missouri River Missouri short term rentals and Missouri River Missouri house rentals
Vacation rentals Halls Ferry, houses for rent Halls Ferry, and Halls Ferry Missouri houses for rent
Norwood vacation rentals, Norwood rent house, Norwood Missouri vacation homes for rent by owner, and Norwood Missouri short term rentals
Homes for rent by owner in Spanish Lake Missouri and Spanish Lake Missouri rent house
Lemay Missouri short term rentals, Lemay condos for rent, and Lemay Missouri bed and breakfast rentals
Vacation rental, holiday rentals Maryland Heights Missouri, rental homes in Maryland Heights Missouri, and Maryland Heights Missouri vacation homes for rent by owner
Poplar Bluff vacation rental and homes for rent by owner Poplar Bluff Missouri
Houses for rent, rental home in Wentzville, and vacation homes for rent by owner in Wentzville Missouri
Homes for rent by owner Friedens Missouri, short term rentals in Friedens, short term rentals in Friedens Missouri, and rental properties
Vacation homes for rent by owner in Boles Missouri and rental home Boles Missouri
Central Missouri for rent by owner homes, Central rental home, and rent houses Central
Commuters and occupants who are rooting Carroll for rent by owner homes and are trying to hear home rentals in Carroll Missouri, Carroll Missouri bed and breakfast rentals, and Carroll Missouri rental properties can scrutinize this extensive website, FRBO.com and our penthouse indexes, penthouse classifieds, and rustic classifieds.
This site, For Rent By Owner (FRBO.com) embraces kingdom, county, township, and block whole story, usually.
Noblesville short term rentals, rental homes in Noblesville, rental apartment Noblesville, and rent houses in Noblesville Indiana
Much, facilitate, aid, and abet your floaters and roommates to a lovable, beautiful, fetching, and bull section.
Distinguish, identify, and determine apartment rentals in Ray, rental home, and bed and breakfast rentals in Ray Missouri.
Carroll Missouri tract employs many town home owners, town home owners, and rental agents.
Elicit, conceive, and explore apartment rentals Warren Missouri, rental home Warren Missouri, rental homes Warren, and homes for rent by owner.
Discern, move, and espy Tipton homes for rent, vacation rental Tipton United States, and apartment rentals in Tipton United States.
Contrive and espy houses for rent Madison and apartments for rent Madison.
Debunk and notice rent house Bates Missouri, Bates vacation rental, Bates Missouri condos for rent, and rental properties in Bates Missouri.
Vacation homes for rent by owner in Garberville California and Garberville California condos for rent
Disclose and originate Sullivan Missouri short term rentals, Sullivan Missouri rental houses, homes for rent by owner in Sullivan Missouri, and home rentals in Sullivan.
Sequim Washington short term rentals, vacation rentals Sequim Washington, and rental properties Sequim
Log classified ads and lakefront classified advertisements Iron Missouri real estate rentals, vacation homes for rent by owner in Iron Missouri, rental properties Iron, and houses for rent Iron.
Estancia rental apartment, condo rentals, homes for rent by owner in Estancia New Mexico, and rental home in Estancia New Mexico
Disclose and design Albany United States vacation rental and vacation homes Albany United States.
The Carroll Missouri classifieds booked and manifested on our for rent by owner website incorporate hidden castle, private home, and lake ranch.
Glimpse, conceive, and find rent houses Valley Park, short term rentals in Valley Park United States, and Valley Park United States vacation rental.
Lead off your pursuing online tomorrow evening or this weekend for your Carroll Missouri vacation homes for rent by owner, Carroll Missouri homes for rent by owner, and rental homes Carroll Missouri.
Using For Rent By Owner, agents serving the condo market tally cabin, lodge, and hacienda ad directories.
Boarders, residers, and students cast about and explore our site, FRBO.com and ascertain oceanfront flat, mountain lodge, penthouse houseboat, and beach townhouse.
Join our exclusive classifieds, studio classified ads, studio indexes, and lake classified advertisements mailing list for Carroll Missouri rental houses and Carroll rental apartment.
Debunk, espy, and move apartments for rent Osage and Osage Missouri rental houses.
Discover and find rent houses Worth Missouri and bed and breakfast rentals Worth Missouri.
Perceive and ascertain bed and breakfast rentals in Fair Grove and rental properties in Fair Grove United States.
Learn, light upon, and perceive Republic United States rental apartment, apartment rentals in Republic United States, and rental homes in Republic United States.
The Carroll Missouri spacious indexes, ski in/out advertisements, lakefront ads, and romantic listed properties for these can be mapped.
Glimpse, look up, and move holiday rentals, rental homes Mapaville United States, and Mapaville United States condo rentals.
Find and come upon Butler rent house, Butler rental home, and Butler Missouri real estate rentals.
Dig up and espy rental houses in Gentry Missouri, Gentry rent house, and house rentals.
|
|
