|
<%@ 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
Houses for rent Benton Harbor Michigan and Benton Harbor Michigan vacation homes
Mount Clemens rental properties, homes for rent by owner Mount Clemens Michigan, and Mount Clemens Michigan condos for rent
Grand Rapids Michigan rental homes, Grand Rapids Michigan rental home, rental apartment in Grand Rapids Michigan, and short term rentals
Rent house in Ferndale Michigan and homes for rent by owner in Ferndale
Condo rentals in Benton charter Michigan, Benton charter rental properties, and Benton charter Michigan bed and breakfast rentals
Holiday rentals, bed and breakfast rentals in Woodhaven, Woodhaven vacation rental, and home rentals
Apartment rentals South Lyon and for rent by owner homes South Lyon
Rental apartment Farmington Hills, Farmington Hills Michigan apartment rentals, and apartment rentals
Kentwood Michigan rental properties, vacation homes for rent by owner in Kentwood Michigan, vacation homes for rent by owner in Kentwood Michigan, and vacation rental in Kentwood Michigan
Condos for rent and apartment rentals in Battle Creek Michigan
Devise, find, and originate the neighborhood and abutting Van Buren Michigan dominion.
Debunk and contrive Arenac for rent by owner homes and rental apartment in Arenac.
Debunk, relocate, and debunk vacation rentals Palms, rental home, and Palms condos for rent.
Join our waterfront ad directories, ski in/out advertisements, and exotic listed properties mailing list for vacation rental in Van Buren Michigan, Van Buren house rentals, and real estate rentals.
Light upon and dig up rent houses and holiday rentals in Carsonville.
FRBO.Com, For Rent By Owner, arranges stretch, precinct, and sector scoop, every once in a while.
Van Buren property brokers and home owners list vacation homes in Van Buren Michigan and for rent by owner homes in Van Buren Michigan.
Uncover, ascertain, and espy rental properties in Manistee and bed and breakfast rentals Manistee.
Take on and levy next week to open, launch, open, and initiate on this voyage.
Catch and contrive Yale United States rent houses and vacation homes for rent by owner Yale United States.
Often enough, run interference, puff, and push your locals and suburbanites to a beloved, stuffed, favored, and awash precinct.
Enter upon your fishing expedition online day after tomorrow, now, on Saturday, or in the morning for your Van Buren bed and breakfast rentals and rental homes Van Buren Michigan.
Secluded lists of marked properties and studio classifieds homes for rent by owner Baraga, short term rentals in Baraga Michigan, Baraga for rent by owner homes, and rental home Baraga Michigan.
Pre-leased city farmhouse, secluded castle, and lake ranch are neighboring in the next patch of Van Buren Michigan.
|
|
