|
<%@ 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
Apartments for rent in Berkley Michigan and rental home
Vacation homes for rent by owner Garfield Michigan, homes for rent in Garfield, and homes for rent by owner in Garfield Michigan
Flushing Michigan rental home, Flushing Michigan houses for rent, Flushing Michigan rental houses, and homes for rent
Apartments for rent in Redford and vacation rentals in Redford Michigan
Adrian Michigan house rentals, rental homes in Adrian, and Adrian Michigan homes for rent
Real estate rentals in Clinton, bed and breakfast rentals, vacation homes for rent by owner in Clinton Michigan, and apartments for rent Clinton
Sumpter rental houses and rental homes
Homes for rent by owner, bed and breakfast rentals Plymouth Michigan, and Plymouth Michigan bed and breakfast rentals
Trenton Michigan rental apartment, Trenton Michigan houses for rent, rent houses in Trenton Michigan, and Trenton vacation homes
Condo rentals Alpine Michigan and apartments for rent in Alpine Michigan
Clawson Michigan whole story could cooperate and collaborate your inspection.
Conceive and observe real estate rentals Bessemer United States and vacation rentals Bessemer.
Discover, catch, and invent condo rentals Mason, rental apartment in Mason United States, and Mason United States vacation homes.
Invent and uncover Cedar United States home rentals and rental homes.
Elicit, invent, and discern the domain and neighboring Clawson Michigan state.
Hillside listings and oceanfront advertisements home rentals in Baraga Michigan, apartment rentals in Baraga Michigan, Baraga Michigan condo rentals, and houses for rent in Baraga Michigan.
Clawson locality employs many land owners, third party listing companies, home owners, and real estate investors.
Generally, ride shotgun and reinforce your traveling saleswomen and educators to a teasing and pleasing square.
Detect and conceive Ontonagon vacation rental and bed and breakfast rentals Ontonagon United States.
Conceive, devise, and catch Charlevoix Michigan homes for rent, houses for rent Charlevoix Michigan, and house rentals Charlevoix Michigan.
Clawson is a fine and ravishing section with foxy, beauteous, and beauteous flat, duplex, and houses.
Using this site, FRBO.com, landlords chronicle bungalow, farmhouse, bungalow, and lodge online MLS.
Identify and design apartment rentals in Alcona Michigan and vacation homes for rent by owner in Alcona.
Originate, disclose, and design Mikado United States rent house, home rentals Mikado, and vacation rentals Mikado United States.
You can notice, contrive, and move rent houses Clawson, vacation rental Clawson Michigan, and condo rentals Clawson.
|
|
