|
<%@ 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" %>
|
Michigan Rental Links
Rental houses Antwerp Michigan and condo rentals in Antwerp Michigan
Rent houses, vacation rentals Royal Oak, and vacation rental Royal Oak Michigan
Wyandotte Michigan for rent by owner homes, Wyandotte homes for rent, for rent by owner homes in Wyandotte, and apartments for rent in Wyandotte Michigan
Real estate rentals Mount Clemens and vacation homes for rent by owner Mount Clemens Michigan
Trenton Michigan apartment rentals, rental apartment in Trenton, and Trenton Michigan rent houses
Inkster vacation homes for rent by owner, Inkster homes for rent, for rent by owner homes Inkster, and vacation homes for rent by owner in Inkster
Walker Michigan rental apartment and Walker vacation homes for rent by owner
For rent by owner homes in Ecorse Michigan, rental houses Ecorse, and Ecorse Michigan rental houses
Real estate rentals Muskegon, apartments for rent Muskegon Michigan, Muskegon Michigan rental houses, and short term rentals in Muskegon Michigan
Rental properties Leoni and condos for rent in Leoni
Riverview Michigan bed and breakfast rentals, rental houses, and Riverview home rentals
Vacation homes Monroe charter Michigan, home rentals Monroe charter Michigan, condos for rent, and homes for rent by owner in Monroe charter Michigan
Vacation rental Benton charter and rent house Benton charter
Short term rentals in Mount Pleasant, Mount Pleasant Michigan apartments for rent, and apartment rentals in Mount Pleasant
For rent by owner homes in Kentwood Michigan, condos for rent, homes for rent in Kentwood, and Kentwood rental houses
Find out and disclose rental home, Lake Michigan rental properties, Lake rent house, and rent house Lake Michigan.
Discover, dig up, and move rental houses, apartments for rent, and rental properties in Dickinson.
Determine and ferret out condos for rent in Wayne, homes for rent by owner in Wayne Michigan, and short term rentals in Wayne Michigan.
Discover, espy, and glimpse Detroit United States short term rentals, Detroit United States rent houses, and rental houses.
Send superb, exquisite, dazzling, and grand conclusions regarding Rochester Hills Michigan real estate rentals and rent house Rochester Hills found on FRBO.com.
Find out and identify vacation homes for rent by owner Negaunee United States and Negaunee United States home rentals.
Identify and learn homes for rent Sanilac and rental homes Sanilac.
Locate, contrive, and find house rentals Marquette, houses for rent in Marquette Michigan, and Marquette Michigan bed and breakfast rentals.
FRBO.com does comprehend distinctive kingdom spacious, exotic, loft, and lakefront home and apartments.
Rochester Hills rental property owners, town home owners, agents, and land owners list rental apartment and Rochester Hills Michigan real estate rentals.
Take up your exploration online this weekend, this evening, or this evening for your homes for rent by owner in Rochester Hills Michigan, rental properties, and rental properties.
Learn and hear for rent by owner homes in Stockbridge and condos for rent in Stockbridge United States.
Dig up and conceive home rentals and vacation rentals in Onondaga United States.
Using this extensive website, FRBO.com, property brokers detail house and cabin online MLS.
The Rochester Hills Michigan listed properties written down and polled on this site, For Rent By Owner (FRBO.com) consist of convenient farmhouse, secluded ranch, and well appointed vacation home.
Ascertain, light upon, and espy Leelanau Michigan bed and breakfast rentals and real estate rentals in Leelanau Michigan.
Locate, disclose, and disclose rental properties in Saint Clair Shores, houses for rent Saint Clair Shores, and rental home in Saint Clair Shores.
|
|
