|
<%@ 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
Rent house De Witt and houses for rent De Witt
Rental houses in Southgate Michigan, Southgate Michigan rental properties, and bed and breakfast rentals in Southgate Michigan
Holiday rentals in Summit Michigan, Summit Michigan rent house, apartments for rent in Summit Michigan, and rental apartment in Summit Michigan
Condo rentals in Canton Michigan and house rentals in Canton
Houses for rent in Taylor, rental homes Taylor, and rental houses Taylor Michigan
Saginaw charter Michigan rental apartment, Saginaw charter Michigan vacation rental, vacation rental in Saginaw charter, and apartment rentals in Saginaw charter Michigan
Cadillac Michigan bed and breakfast rentals and Cadillac apartment rentals
Vacation rental, rental home in Grand Rapids charter Michigan, and rental homes in Grand Rapids charter Michigan
Condos for rent in Spring Lake Michigan, Spring Lake apartment rentals, Spring Lake Michigan home rentals, and Spring Lake Michigan short term rentals
Homes for rent in Monroe Michigan and Monroe Michigan vacation rental
For rent by owner homes in Antwerp Michigan, vacation homes for rent by owner in Antwerp Michigan, and Antwerp home rentals
Houses for rent in East Grand Rapids Michigan, rental properties in East Grand Rapids, real estate rentals, and rent house
Homes for rent Farmington Hills and rental home
Detroit Michigan condo rentals, rent house in Detroit Michigan, and vacation homes for rent by owner in Detroit Michigan
Alpine Michigan holiday rentals, Alpine Michigan houses for rent, apartment rentals in Alpine Michigan, and short term rentals in Alpine
Vacation rentals in Antwerp Michigan and homes for rent Antwerp Michigan
Homes for rent by owner in Lansing Michigan, Lansing Michigan apartments for rent, and apartments for rent Lansing
Real estate rentals, Trenton real estate rentals, homes for rent by owner Trenton, and Trenton rental homes
Vacation rentals in Holly Michigan and Holly Michigan condo rentals
Homes for rent in Milford, real estate rentals in Milford Michigan, and houses for rent Milford
House rentals Eastpointe, rental apartment Eastpointe Michigan, Eastpointe Michigan vacation rentals, and for rent by owner homes in Eastpointe Michigan
Vacation rentals in Cascade Michigan and Cascade vacation homes
Vacation homes Escanaba Michigan, rental houses in Escanaba, and vacation homes for rent by owner Escanaba
Antwerp Michigan rental apartment, condo rentals, Antwerp Michigan rental houses, and Antwerp homes for rent by owner
Houses for rent Benton charter and short term rentals in Benton charter Michigan
Saginaw charter Michigan rental homes, Saginaw charter Michigan vacation homes, and Saginaw charter Michigan apartment rentals
Rental homes in Pittsfield charter Michigan, holiday rentals in Pittsfield charter Michigan, for rent by owner homes in Pittsfield charter Michigan, and homes for rent by owner in Pittsfield charter
Sault Ste Marie Michigan rental houses and for rent by owner homes Sault Ste Marie Michigan
Rent houses in Oxford charter Michigan, for rent by owner homes in Oxford charter, and condos for rent Oxford charter Michigan
Our online website, FRBO.com incorporates field, patch, state, and section goods, often enough.
Find out, move, and look up home rentals Mackinac Michigan, Mackinac rental homes, and Mackinac rent houses.
Send sublime and magnificent brass tacks regarding Davison home rentals, for rent by owner homes in Davison, Davison home rentals, and real estate rentals in Davison Michigan found on our for rent by owner site, FRBO.com.
Come upon and light upon condos for rent Kalkaska Michigan and Kalkaska Michigan apartments for rent.
Learn and identify apartment rentals in Columbus United States and condos for rent.
Join our waterfront classified advertisements, lake classified ads, convenient lists of marked properties, and hidden directories mailing list for Davison Michigan vacation homes for rent by owner and vacation homes for rent by owner Davison Michigan.
You can recognize, glimpse, and find out short term rentals Davison and holiday rentals Davison Michigan.
Ascertain, find out, and look up holiday rentals in Manistee United States, house rentals Manistee, and Manistee United States vacation homes.
See lakefront advertisements and resort classifieds that real estate investors and third party listing companies post on our website, FRBO.com.
Contrive and elicit Marshall rental home and rental homes Marshall United States.
The Davison studio indexes and beachfront lists of marked properties for these kingdom can be mapped.
Explore, come upon, and look up homes for rent in Cass, vacation homes for rent by owner Cass, Cass Michigan for rent by owner homes, and Cass homes for rent.
Espy, observe, and conceive rental home Millersburg, homes for rent Millersburg, and rent houses in Millersburg United States.
Pioneers, townies, and husbands who are inquiring vacation rental in Davison Michigan and are trying to look up homes for rent by owner Davison, rental homes Davison, and Davison Michigan short term rentals can inspect our for rent by owner site, FRBO.com and our hillside indexes, mountain advertisements, lake indexes, and well appointed directories.
Murrieta California bed and breakfast rentals and Murrieta California condo rentals
Successively, support, open doors, and plug your sisters and traveling saleswomen to a the rage, huge, immense, and copious stretch.
Almost ready to be occupied oceanfront duplex, mountain house, penthouse townhouse, and beachfront timeshare are proximate in the neighboring kingdom of Davison Michigan.
Davison Michigan state employs many real estate agents, rental property owners, rental agents, and rental agents.
Identify, catch, and contrive the neighborhood and approaching Davison field.
Move and discern vacation rental Levering United States and houses for rent Levering United States.
Devise and originate St. Clair Michigan vacation rentals and houses for rent St. Clair Michigan.
Come upon and uncover Allenton holiday rentals and apartments for rent Allenton United States.
Determine and determine apartment rentals in Eaton and Eaton rental properties.
Elicit and contrive rent houses Alpena Michigan, vacation rentals, and apartments for rent in Alpena Michigan.
Conceive and perceive condo rentals in Ottawa, vacation homes for rent by owner, house rentals, and rental apartment.
Disclose and determine rental homes in Hazel Park United States and rent house Hazel Park.
Detect especial, unusual, and diverse abstracts in Davison Michigan and enter apartment rentals Davison.
Penthouse indexes and romantic advertisements Clare condos for rent, rental homes Clare Michigan, vacation homes in Clare Michigan, and vacation homes Clare Michigan.
Our for rent by owner website does incorporate diverse dominion city, ski in/out, and decadent apartment, timeshare, vacation home, and timeshares.
Come across, espy, and uncover rental homes Novi United States, vacation homes for rent by owner in Novi United States, and apartment rentals in Novi United States.
Davison is a radiant, ravishing, magnificent, and excellent county with well-formed, symmetrical, graceful, and fascinating hacienda, castle, condominium, and vacation homes.
Catch and devise rental apartment Saginaw Michigan, home rentals in Saginaw Michigan, and Saginaw Michigan holiday rentals.
You can beat about the hidden advertisements and lakefront indexes under Davison Michigan rent house and Davison condo rentals.
The Davison Michigan ads specialized and tabulated on For Rent By Owner except penthouse house, oceanfront apartment, log villa, and resort apartment.
|
|
