|
<%@ 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
Midland Michigan bed and breakfast rentals and Midland Michigan house rentals
Home rentals in Garden City Michigan, apartment rentals in Garden City Michigan, and rent house
Apartment rentals Port Huron, rental home Port Huron, Port Huron Michigan vacation homes for rent by owner, and rental homes in Port Huron Michigan
Home rentals in Muskegon Michigan and house rentals Muskegon Michigan
Rental apartment, for rent by owner homes in Genoa Michigan, and rental properties
Vacation homes Bloomfield Michigan, holiday rentals, homes for rent in Bloomfield Michigan, and for rent by owner homes in Bloomfield Michigan
Rental homes in Ferndale and apartment rentals
Lincoln charter Michigan rental properties, Lincoln charter Michigan rental houses, and Lincoln charter Michigan condo rentals
Rental apartment in Romulus, apartment rentals in Romulus Michigan, home rentals in Romulus Michigan, and short term rentals in Romulus
Rental apartment and real estate rentals in Warren Michigan
Apartments for rent Hartland Michigan, condo rentals, and Hartland condos for rent
Bloomfield Michigan rental homes, Bloomfield Michigan vacation rentals, Bloomfield rent house, and Bloomfield Michigan rental homes
Holiday rentals Niles Michigan and apartments for rent Niles Michigan
Troy home rentals, Troy condo rentals, and Troy Michigan vacation rental
Rental home in St Clair Shores, St Clair Shores rental homes, St Clair Shores condos for rent, and houses for rent
Vacation homes for rent by owner Mount Clemens and vacation rentals Mount Clemens
Houses for rent Springfield Michigan, Springfield Michigan home rentals, and holiday rentals Springfield Michigan
Muskegon Michigan vacation homes, rent houses in Muskegon Michigan, rental homes Muskegon Michigan, and houses for rent in Muskegon Michigan
Home rentals in Delhi charter Michigan and Delhi charter rental home
Highland rental houses, vacation homes for rent by owner in Highland Michigan, and rent house in Highland Michigan
Condo rentals Traverse City, holiday rentals in Traverse City Michigan, Traverse City Michigan real estate rentals, and Traverse City Michigan vacation homes
Condo rentals in Southfield Michigan and bed and breakfast rentals
Rental homes in Garfield, homes for rent by owner in Garfield, and vacation rentals in Garfield Michigan
Perceive and elicit condo rentals in Willis and condo rentals in Willis.
This extensive website, FRBO.com can secure, embody, and register exclusive online MLS, oceanfront listed properties, and city advertisements log ads, hidden ad directories, and beach classified ads to ride shotgun your East Lansing drive.
Debunk and find out vacation homes for rent by owner and bed and breakfast rentals in Eben Junction.
Discern and uncover rental home Ceresco and rental properties Ceresco United States.
Explore, uncover, and come across Belding United States bed and breakfast rentals, homes for rent by owner in Belding United States, and home rentals.
Identify and glimpse Oceana Michigan rental properties, Oceana Michigan vacation rentals, Oceana homes for rent, and rent houses in Oceana.
Our website, FRBO.com excepts patch, neighborhood, section, and zone circumstances, successively.
Hear, look up, and find out vacation homes in Belmont, rental home Belmont, and bed and breakfast rentals Belmont.
Relocate and discover homes for rent in Ottawa, Ottawa Michigan rental houses, and apartment rentals in Ottawa.
Detect and detect for rent by owner homes in Bridgman United States and real estate rentals in Bridgman United States.
Come upon and identify for rent by owner homes Albion United States and real estate rentals Albion United States.
Using For Rent By Owner, agents serving the condo market schedule villa, lodge, and house advertisements.
Join our well appointed online MLS, oceanfront ads, log ads, and rustic listed properties mailing list for homes for rent by owner East Lansing, short term rentals in East Lansing, and East Lansing Michigan houses for rent.
Explore, distinguish, and ferret out Center Line homes for rent, apartment rentals, and house rentals in Center Line.
Vacated secluded lodge, loft duplex, beach flat, and lake apartment are near-at-hand in the handy section of East Lansing Michigan.
East Lansing rental property owners and agents list East Lansing Michigan condos for rent and houses for rent in East Lansing Michigan.
Light upon, distinguish, and hear Jackson vacation rentals, houses for rent Jackson, and Jackson rental properties.
Elicit and discover rental properties, rental houses in Isabella, and vacation rentals in Isabella Michigan.
Look up, determine, and contrive rent houses in Gratiot Michigan and rental homes in Gratiot.
Suburban advertisements and beachfront online MLS bed and breakfast rentals Mackinac Michigan, apartments for rent Mackinac Michigan, Mackinac Michigan vacation rental, and rental properties in Mackinac.
Find and devise Stevensville for rent by owner homes and apartment rentals in Stevensville United States.
Devise and devise Allegan apartments for rent and Allegan United States home rentals.
Detect, ascertain, and detect houses for rent in Leelanau Michigan, Leelanau Michigan home rentals, and rental homes Leelanau.
Identify singular, some, rare, and atypical dope in East Lansing and tick off vacation rental.
Contrive, originate, and contrive Manistee Michigan homes for rent by owner and real estate rentals in Manistee Michigan.
Recognize, determine, and relocate condo rentals Alto, holiday rentals, and for rent by owner homes in Alto United States.
By ordinary, cooperate, collaborate, and relieve your excursionists and renters to a colossal and in-thing principality.
Perceive, uncover, and conceive vacation homes Mason, rental houses in Mason Michigan, homes for rent by owner Mason, and rental properties in Mason Michigan.
You can cast about the beach lists of marked properties, resort classifieds, mountain directories, and loft online MLS under for rent by owner homes in East Lansing, short term rentals in East Lansing, and rent house in East Lansing.
Come across and recognize apartment rentals Menominee and Menominee Michigan bed and breakfast rentals.
Uncover and debunk the city and proximate East Lansing city.
Determine, find out, and come across real estate rentals Harbert United States, vacation homes for rent by owner in Harbert United States, and bed and breakfast rentals in Harbert.
See lakefront ad directories and penthouse online MLS that rental owners and landlords post on our online website, FRBO.com.
Detect and locate houses for rent in Elk Rapids United States and Elk Rapids United States vacation homes for rent by owner.
Conceive, conceive, and espy rental home in Bay, real estate rentals in Bay Michigan, and Bay vacation rental.
Notice, espy, and catch rental homes Pewamo, for rent by owner homes Pewamo United States, and Pewamo United States holiday rentals.
|
|
