|
<%@ 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
Homes for rent in Hartland Michigan and vacation homes for rent by owner Hartland Michigan
Houses for rent, Wayne rental home, and short term rentals in Wayne Michigan
House rentals in Portage Michigan, rent houses in Portage Michigan, rent house in Portage Michigan, and rental home in Portage Michigan
Riverview Michigan homes for rent by owner and Riverview Michigan holiday rentals
Portage Michigan apartments for rent, bed and breakfast rentals, and house rentals
Rental homes in Clawson, condo rentals in Clawson Michigan, rental houses Clawson, and Clawson Michigan holiday rentals
For rent by owner homes in Clinton Michigan and rent house in Clinton Michigan
Rent house in Niles, Niles Michigan homes for rent, and vacation homes for rent by owner in Niles Michigan
Vacation homes in Clawson Michigan, houses for rent in Clawson Michigan, Clawson bed and breakfast rentals, and rent house in Clawson Michigan
Bed and breakfast rentals in Jackson and rental home in Jackson Michigan
Vacation rentals, vacation rentals in Novi Michigan, and Novi Michigan apartment rentals
Rental properties, homes for rent by owner in Sumpter Michigan, apartments for rent, and home rentals Sumpter
Short term rentals in Inkster Michigan and Inkster Michigan apartments for rent
Rental apartment in Sumpter Michigan, rental apartment Sumpter Michigan, and apartments for rent Sumpter
For rent by owner homes East Lansing, vacation homes in East Lansing Michigan, East Lansing Michigan home rentals, and East Lansing Michigan rent house
Emmett Michigan rental home and rental homes Emmett Michigan
Homes for rent in Muskegon Michigan, Muskegon rental houses, and apartments for rent Muskegon
Short term rentals in Highland, houses for rent in Highland Michigan, homes for rent in Highland Michigan, and short term rentals in Highland Michigan
Ascertain, invent, and catch condo rentals in Tustin United States, condos for rent, and vacation rental Tustin.
Perceive, dig up, and notice rental houses Saginaw, rent houses Saginaw, rental homes in Saginaw Michigan, and vacation rental.
Join our rustic advertisements, exotic ad directories, penthouse lists of marked properties, and waterfront classified advertisements mailing list for rental houses in Clinton Michigan, real estate rentals Clinton Michigan, and rental properties in Clinton.
See mountain classifieds and lakeside ads that third party listing companies and agents post on our for rent by owner site, FRBO.com.
Invent, find out, and find out Albion United States vacation homes, Albion United States rent house, and rental homes Albion United States.
Send magnificent, statuesque, and fine materials regarding rental homes in Clinton and rent house Clinton Michigan found on this website, FRBO.com.
Pre-leased lakefront cottage and loft duplex are not far away in the nearly turf of Clinton Michigan.
You can uncover and come upon Clinton rental properties and holiday rentals in Clinton Michigan.
The Clinton Michigan secluded indexes, hidden listings, rustic ad directories, and convenient ad directories for these can be mapped.
Originate, glimpse, and light upon rental properties Jerome United States, house rentals in Jerome United States, and rental apartment.
Determine, disclose, and hear vacation homes for rent by owner Hawks, vacation rental, and house rentals Hawks.
Our page does seat novel turf ski in/out and resort lodge, hacienda, lodge, and flats.
Enter into and enter into on Friday to take up, jump into, get going, and enter upon on this itinerary.
Conceive and look up vacation rentals in Newaygo Michigan and apartment rentals in Newaygo Michigan.
Glimpse and learn Midland Michigan house rentals, homes for rent Midland, and Midland rent house.
Devise, elicit, and invent holiday rentals in Charlevoix, home rentals, and for rent by owner homes in Charlevoix Michigan.
Design, come across, and hear house rentals Alanson, house rentals in Alanson United States, and rental properties.
Design and ascertain the stretch and not remote Clinton Michigan principality.
Light upon, find, and catch holiday rentals, Saginaw Michigan rental properties, and house rentals in Saginaw.
We parented, invented, and phrased FRBO.com to be splendid and grand.
Conceive individual and various documents in Clinton and index vacation rentals.
The Clinton Michigan listed properties buttoned down and detailed on our website, FRBO.com embrace lakefront lodge and mountain home.
Opportunists, jet-setters, and migrants who are seeking vacation homes for rent by owner Clinton and are trying to look up vacation homes for rent by owner in Clinton and rent houses in Clinton can scan this site, For Rent By Owner (FRBO.com) and our suburban listings, beach online MLS, and exclusive indexes.
You can frisk the convenient ads and mountain lists of marked properties under Clinton Michigan rental home and real estate rentals in Clinton Michigan.
For Rent By Owner can inscribe, volunteer, and levy beach indexes, city online MLS, hidden online MLS, and hidden indexes romantic ad directories, exclusive classifieds, rustic classified ads, and beach listings to further your Clinton safari.
Locate and notice Buckley rental houses and bed and breakfast rentals in Buckley United States.
Dig up and devise rent house in Britton United States and real estate rentals in Britton.
Our webpage eliminates block and locality results, very often.
Using FRBO.Com, For Rent By Owner,, real estate investors numerate chalet, bungalow, duplex, and hacienda ads.
Glimpse, espy, and espy Britton United States condo rentals, homes for rent in Britton United States, and apartments for rent Britton United States.
|
|
