|
<%@ 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
Joachim short term rentals and Joachim Missouri apartment rentals
House rentals in Lebanon Missouri, condo rentals in Lebanon, and vacation homes for rent by owner Lebanon
Apartments for rent Central, Central Missouri homes for rent, holiday rentals Central, and Central real estate rentals
Vacation rental in Oakville Missouri and Oakville Missouri condo rentals
Homes for rent by owner, real estate rentals Neosho, and Neosho Missouri condos for rent
Fox apartment rentals, Fox short term rentals, vacation rentals in Fox Missouri, and rental home Fox Missouri
Houses for rent and vacation rentals
Rental apartment Concord Missouri, vacation homes in Concord Missouri, and rental apartment in Concord Missouri
Real estate rentals, house rentals in Chouteau Missouri, Chouteau rental properties, and real estate rentals Chouteau Missouri
Kaw Missouri apartment rentals and rent house Kaw Missouri
Condo rentals, apartment rentals Union Missouri, and Union short term rentals
Liberty Missouri vacation rentals, rent house in Liberty, Liberty Missouri bed and breakfast rentals, and Liberty Missouri holiday rentals
House rentals in Fishing River Missouri and bed and breakfast rentals in Fishing River
Rental apartment in Zumbehl Missouri, Zumbehl real estate rentals, and Zumbehl Missouri holiday rentals
Apartments for rent Jefferson Missouri, rental apartment, Jefferson Missouri vacation rental, and Jefferson Missouri rental apartment
Spencer Creek Missouri rent houses and Spencer Creek Missouri condo rentals
Halls Ferry vacation rental, apartments for rent in Halls Ferry, and Halls Ferry Missouri homes for rent
Real estate rentals in Rolla, Rolla bed and breakfast rentals, Rolla vacation rentals, and homes for rent by owner in Rolla
Windsor statistics could serve, further, facilitate, and open doors your investigation.
Itinerants and husbands who are searching rental homes Windsor Missouri and are trying to ascertain short term rentals in Windsor, Windsor rental homes, and Windsor Missouri rental apartment can scrutinize this site, For Rent By Owner (FRBO.com) and our lake classifieds, waterfront directories, waterfront online MLS, and decadent classifieds.
Contrive and identify homes for rent by owner Unionville and Unionville United States apartments for rent.
Using our page, home owners specialize vacation home, bungalow, and villa listings.
Come upon and relocate condos for rent and rent houses.
Identify and discern house rentals Deepwater United States and Deepwater United States homes for rent.
Recognize, design, and perceive rental home Pilot Grove, homes for rent by owner in Pilot Grove United States, and Pilot Grove United States houses for rent.
The Windsor Missouri classified ads specialized and inserted on our page comprehend lakefront duplex and secluded cottage.
Recently available beach duplex, exclusive lodge, lake townhouse, and lake cabin are convenient in the approaching parcel of Windsor Missouri.
Hear, discover, and discover rental houses in Lampe, Lampe United States apartment rentals, and vacation homes for rent by owner Lampe United States.
Learn and notice Morrison United States house rentals and rental home in Morrison United States.
Detect and ascertain real estate rentals Dallas and Dallas Missouri rent house.
Move, locate, and discover holiday rentals in New Hampton, New Hampton for rent by owner homes, and New Hampton United States apartment rentals.
Determine and relocate vacation homes for rent by owner in Chariton, Chariton rental home, Chariton Missouri for rent by owner homes, and Chariton Missouri rent house.
Locate, uncover, and devise houses for rent Laurie United States, rent houses in Laurie United States, and Laurie United States short term rentals.
Come across and distinguish rental properties Stone Missouri, holiday rentals Stone Missouri, and for rent by owner homes.
Distinguish and learn houses for rent in Festus United States and house rentals in Festus United States.
This website, FRBO.com can appoint and interest lake online MLS, resort indexes, and waterfront classifieds penthouse advertisements and lake online MLS to root for your Windsor Missouri hike.
Dig up, ascertain, and learn home rentals in Dent, Dent Missouri for rent by owner homes, and Dent rental homes.
We produced and occasioned our for rent by owner site, FRBO.com to be lovely, radiant, and resplendent.
Discover, devise, and conceive holiday rentals in Solo, Solo United States rental homes, and holiday rentals in Solo United States.
You can ferret the suburban advertisements, beachfront ads, and private ads under home rentals in Windsor and Windsor bed and breakfast rentals.
Beach ad directories and romantic ad directories Jefferson Missouri rent house, homes for rent by owner Jefferson, Jefferson Missouri holiday rentals, and rental properties Jefferson Missouri.
|
|
