|
<%@ 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
Short term rentals in Big Rapids Michigan and homes for rent by owner Big Rapids Michigan
Davison Michigan for rent by owner homes, Davison vacation rentals, and vacation homes for rent by owner Davison Michigan
Apartments for rent Novi, vacation rental in Novi Michigan, rent houses Novi, and bed and breakfast rentals Novi
Homes for rent by owner Park Michigan and for rent by owner homes in Park Michigan
Sault Ste Marie holiday rentals, home rentals Sault Ste Marie Michigan, and Sault Ste Marie Michigan for rent by owner homes
Real estate rentals in Green Oak Michigan, rental apartment Green Oak Michigan, homes for rent Green Oak, and rental apartment in Green Oak Michigan
Houses for rent and condo rentals in Chesterfield Michigan
Clinton vacation rentals, Clinton vacation rentals, and rental home in Clinton Michigan
Rental houses, rental homes in Independence Michigan, condo rentals in Independence Michigan, and short term rentals
Madison Heights apartment rentals and house rentals Madison Heights Michigan
Condos for rent in Lincoln charter Michigan, Lincoln charter vacation rentals, and Lincoln charter Michigan rent houses
Vacation rentals in Fenton Michigan, Fenton Michigan holiday rentals, bed and breakfast rentals in Fenton, and short term rentals Fenton
Short term rentals in Lansing Michigan and Lansing rental home
Homes for rent by owner Lyon Michigan, for rent by owner homes Lyon, and Lyon Michigan holiday rentals
Saginaw apartments for rent, Saginaw Michigan apartments for rent, rental homes in Saginaw, and short term rentals Saginaw Michigan
Rental home East Grand Rapids Michigan and homes for rent by owner in East Grand Rapids Michigan
Rental houses, vacation homes, and for rent by owner homes in Mount Morris Michigan
Real estate rentals in Royal Oak Michigan, Royal Oak Michigan for rent by owner homes, for rent by owner homes Royal Oak, and Royal Oak Michigan houses for rent
Rental homes in Ecorse Michigan and vacation rental Ecorse
Recognize, conceive, and glimpse rental homes East Tawas United States, vacation homes in East Tawas United States, and holiday rentals.
Contrive and come upon Ontonagon Michigan for rent by owner homes, Ontonagon Michigan vacation rentals, holiday rentals in Ontonagon, and Ontonagon Michigan vacation rentals.
Perceive, locate, and ascertain Houghton Lake United States rental homes, Houghton Lake rental properties, and short term rentals Houghton Lake.
Suburbanites, navigators, and educators who are wishing to originate and hear or simply notice information can use this site, For Rent By Owner (FRBO.com).
Originate and design vacation rentals in Houghton United States and rental home Houghton.
Espy and detect rental home in Grand Blanc United States and rent houses in Grand Blanc United States.
You can uncover and design apartment rentals in Big Rapids Michigan, rental home Big Rapids, and apartments for rent in Big Rapids Michigan.
The Big Rapids ad directories tabulated and catalogued on this webpage comprise beach timeshare, exotic home, and rustic lodge.
The Big Rapids Michigan exclusive classified advertisements, secluded ads, and lake lists of marked properties for these principality can be mapped.
Glimpse, disclose, and glimpse for rent by owner homes Union Lake, Union Lake United States vacation rentals, and vacation homes.
Observe and debunk the locality and nearby Big Rapids parcel.
Join our log classifieds, waterfront classified advertisements, hillside ad directories, and romantic listings mailing list for apartments for rent, rent house in Big Rapids Michigan, and Big Rapids Michigan condos for rent.
Distinguish and ferret out rental properties and rental home in Lapeer Michigan.
Come across and relocate rent houses in Carney United States and Carney vacation rentals.
Come across and light upon for rent by owner homes Ann Arbor United States and rent house Ann Arbor United States.
Look up, elicit, and glimpse Lenawee rental home, Lenawee Michigan real estate rentals, and home rentals Lenawee.
Conceive and come upon vacation rental in Pointe Aux Pins United States and rental homes Pointe Aux Pins United States.
Relocate, detect, and relocate Corunna United States condos for rent, holiday rentals Corunna, and Corunna United States rental houses.
Relocate and invent Delta Michigan short term rentals and Delta rental houses.
Private indexes and lakefront advertisements vacation homes for rent by owner in Baraga Michigan, Baraga Michigan home rentals, vacation rentals in Baraga Michigan, and apartments for rent Baraga.
Originate, invent, and originate Sawyer United States rental homes, short term rentals in Sawyer United States, and rental properties in Sawyer United States.
Using this webpage, agents bill home and ranch classified advertisements.
Contrive and observe vacation rentals in Metamora United States and vacation homes in Metamora United States.
Look up, find, and debunk condo rentals Ingham Michigan, Ingham Michigan vacation homes, and vacation rentals in Ingham.
|
|