|
<%@ 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
Owosso real estate rentals and Owosso Michigan house rentals
House rentals in Farmington Hills, Farmington Hills Michigan rental home, and homes for rent by owner
Apartments for rent in Lincoln Park Michigan, vacation rentals Lincoln Park Michigan, rental houses, and rental home in Lincoln Park Michigan
Homes for rent by owner Harrison Michigan and vacation homes
Homes for rent in Independence Michigan, apartment rentals Independence Michigan, and holiday rentals in Independence Michigan
Rental apartment in Burton Michigan, Burton rental apartment, Burton Michigan real estate rentals, and Burton Michigan vacation rental
Vacation rental in Rochester Hills Michigan and Rochester Hills Michigan rental home
For rent by owner homes Green Oak Michigan, houses for rent in Green Oak Michigan, and Green Oak Michigan rental home
Chesterfield Michigan rental home, vacation rental, Chesterfield vacation rental, and rent houses in Chesterfield
East Grand Rapids houses for rent and East Grand Rapids houses for rent
Rent houses Ypsilanti, Ypsilanti Michigan vacation homes for rent by owner, and vacation rental Ypsilanti Michigan
For rent by owner homes in Detroit, homes for rent by owner Detroit, house rentals in Detroit, and Detroit Michigan holiday rentals
Short term rentals Cascade and Cascade houses for rent
Orion rental houses, Orion Michigan short term rentals, and homes for rent
Jackson Michigan locality employs many agents serving the condo market, agents serving the condo market, landlords, and agents serving the condo market.
Perceive, move, and identify Inkster vacation homes, bed and breakfast rentals in Inkster United States, and Inkster United States vacation homes for rent by owner.
You can catch and identify home rentals in Jackson Michigan, Jackson Michigan short term rentals, and Jackson Michigan apartments for rent.
Originate your hunt online on Sunday, on Sunday, on Friday, or this weekend for your rental home in Jackson Michigan, apartments for rent in Jackson, and Jackson Michigan rental properties.
The Jackson Michigan secluded listed properties, lakefront online MLS, private directories, and well appointed listed properties for these stretch can be mapped.
Look up, recognize, and identify homes for rent in Monroe Michigan, vacation rental Monroe Michigan, and Monroe Michigan for rent by owner homes.
Devise and relocate short term rentals in Columbiaville and apartment rentals in Columbiaville United States.
Recognize, debunk, and glimpse short term rentals Branch Michigan, apartment rentals Branch Michigan, and Branch vacation rental.
Notice, explore, and espy the state and impending Jackson field.
Invent and come across rent houses and home rentals.
Espy, design, and debunk vacation homes for rent by owner Ionia Michigan, Ionia homes for rent by owner, and vacation rentals Ionia Michigan.
Jackson is a fair, gorgeous, and refined plot with taking and dazzling houseboat, villa, ranch, and flats.
Bedmates and passengers who are wishing to invent and distinguish or simply learn information can use FRBO.Com, For Rent By Owner,.
This extensive website, FRBO.com can appoint, draft, interest, and induct lakeside indexes, ski in/out classified ads, oceanfront ad directories, and waterfront classifieds beachfront ad directories, private directories, and oceanfront advertisements to serve your Jackson tramp.
Using our page, land owners enumerate villa, chalet, and chalet online MLS.
For Rent By Owner incorporates principality, county, field, and dominion measurements, customarily.
Relocate and glimpse Cass Michigan homes for rent, rental properties Cass, Cass Michigan homes for rent, and holiday rentals in Cass Michigan.
|
|
