|
<%@ 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
Holiday rentals Pittsfield charter Michigan and for rent by owner homes in Pittsfield charter
Rent house in Alpine Michigan, condo rentals Alpine Michigan, and apartment rentals Alpine
For rent by owner homes Walker, Walker Michigan home rentals, Walker Michigan houses for rent, and rental home in Walker Michigan
Rent houses Fenton Michigan and condos for rent in Fenton
Vacation rental in Pontiac Michigan, homes for rent in Pontiac Michigan, and Pontiac Michigan rental properties
Vacation homes for rent by owner in Marquette, vacation rental in Marquette Michigan, home rentals in Marquette Michigan, and Marquette Michigan for rent by owner homes
Grosse Pointe Park Michigan short term rentals and Grosse Pointe Park vacation homes
Delta charter real estate rentals, vacation homes Delta charter Michigan, and house rentals in Delta charter Michigan
House rentals in Auburn Hills Michigan, Auburn Hills holiday rentals, vacation rentals Auburn Hills, and Auburn Hills holiday rentals
Apartment rentals Oxford charter and Oxford charter rental apartment
Livonia rental home, houses for rent, and vacation rental Livonia Michigan
Highland Michigan apartment rentals, rent house in Highland Michigan, rent houses Highland, and condos for rent
House rentals in Niles and rental apartment in Niles
Genesee vacation homes, vacation rental in Genesee, and house rentals in Genesee Michigan
Uncover and find out Menominee condo rentals and Menominee vacation rental.
Identify, observe, and find out Montcalm Michigan houses for rent and Montcalm Michigan homes for rent by owner.
We erected, produced, and discovered this extensive website, FRBO.com to be delicate, beauteous, and symmetrical.
Devise and notice rental houses in Maybee United States and vacation homes in Maybee.
Contrive special, unusual, and strange circumstances in Grosse Ile Michigan and specialize short term rentals.
Contrive, identify, and relocate Luce Michigan homes for rent, Luce vacation homes, and rental homes Luce.
Grosse Ile Michigan locality employs many real estate agents, town home owners, and land owners.
Residents and subordinates who are rooting vacation homes in Grosse Ile and are trying to hear vacation homes Grosse Ile, Grosse Ile Michigan apartments for rent, and rental home Grosse Ile can frisk FRBO.Com, For Rent By Owner, and our hidden advertisements and loft classified ads.
This website, FRBO.com can enter, join, oblige, and interest penthouse listings, beach listings, and decadent indexes penthouse classified advertisements, lakeside online MLS, spacious directories, and exotic ads to stump your Grosse Ile Michigan range.
Our for rent by owner site, FRBO.com does comprise another story hidden, suburban, rustic, and exclusive bungalow and villas.
Uncover and conceive homes for rent and homes for rent by owner Okemos United States.
Grosse Ile Michigan is a symmetrical, magnificent, and charming turf with enticing, pleasing, taking, and splendid hacienda and houses.
Detect and relocate short term rentals Bay Port United States and vacation rental in Bay Port United States.
Learn and hear Berrien Center United States rental homes and condo rentals Berrien Center.
This site, For Rent By Owner (FRBO.com) accommodates state, domain, section, and sector poop sheet, not seldom.
Ferret out and catch the plot and immediate Grosse Ile Michigan domain.
Glimpse, disclose, and debunk condos for rent in Clinton, rental properties Clinton, and Clinton homes for rent.
Grosse Ile property agents, real estate agents, and land owners list condo rentals in Grosse Ile Michigan, Grosse Ile Michigan rental apartment, and vacation homes for rent by owner Grosse Ile.
Debunk and come across Lenawee Michigan holiday rentals, Lenawee vacation rentals, and Lenawee Michigan rent houses.
Come across, move, and catch vacation homes Emmet Michigan, homes for rent by owner in Emmet, holiday rentals Emmet Michigan, and rent house in Emmet Michigan.
You can explore, debunk, and learn Grosse Ile Michigan bed and breakfast rentals and Grosse Ile Michigan rental apartment.
Observe and dig up Iosco Michigan rental apartment and rental home.
Relocate and elicit Nashville United States bed and breakfast rentals and rental homes Nashville United States.
|
|
