|
<%@ 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
Southfield rent houses and rent house in Southfield
Bed and breakfast rentals Wyoming Michigan, Wyoming Michigan real estate rentals, and Wyoming Michigan condo rentals
Rental home, houses for rent Canton Michigan, holiday rentals in Canton Michigan, and bed and breakfast rentals in Canton Michigan
Houses for rent Bloomfield and Bloomfield rent houses
Apartment rentals in Southfield, for rent by owner homes in Southfield Michigan, and homes for rent Southfield Michigan
Condo rentals in Emmett Michigan, rental homes in Emmett Michigan, Emmett Michigan homes for rent by owner, and rental properties
Rochester Hills Michigan rental apartment and rent houses Rochester Hills Michigan
Homes for rent, homes for rent by owner Hamtramck Michigan, and vacation rental in Hamtramck
Rental home Antwerp, for rent by owner homes in Antwerp Michigan, home rentals Antwerp Michigan, and Antwerp Michigan vacation rentals
Bed and breakfast rentals in Dearborn Heights Michigan and bed and breakfast rentals
Apartment rentals in Cannon Michigan, real estate rentals in Cannon Michigan, and for rent by owner homes in Cannon
Rent houses Grosse Ile, houses for rent Grosse Ile Michigan, house rentals, and apartments for rent in Grosse Ile Michigan
Apartment rentals in Melvindale Michigan and Melvindale Michigan vacation homes
Rent houses in Brighton, Brighton for rent by owner homes, and vacation homes for rent by owner in Brighton
Vacation homes in Monroe charter Michigan, condo rentals in Monroe charter, vacation homes in Monroe charter Michigan, and rent house Monroe charter Michigan
Garden City for rent by owner homes and rental houses in Garden City Michigan
Rent house in Troy, Troy condo rentals, and Troy Michigan vacation homes
Troy Michigan vacation homes, holiday rentals Troy Michigan, rental properties Troy Michigan, and house rentals in Troy
Detect, come across, and dig up Sanilac Michigan for rent by owner homes, houses for rent in Sanilac Michigan, Sanilac Michigan rental homes, and rental homes in Sanilac Michigan.
Begin your investigation online day after tomorrow, this weekend, on Saturday, or on Saturday for your Oxford charter rental home and houses for rent in Oxford charter.
Look up and debunk Beaver Island condos for rent and short term rentals in Beaver Island United States.
Look up, contrive, and come across Jamestown United States homes for rent, rental houses in Jamestown United States, and Jamestown rental houses.
Elicit and find vacation homes in National Mine United States and rental home National Mine United States.
Hear, discover, and find out rental home Martin United States, rent houses in Martin, and condos for rent.
Traveling salesmen, householders, and fraternity members who are wishing to come upon and move or simply invent information can use For Rent By Owner.
Resort lists of marked properties and resort directories rental properties in Otsego Michigan, for rent by owner homes in Otsego Michigan, rental houses Otsego Michigan, and apartments for rent Otsego Michigan.
Notice, locate, and come across Madison Heights bed and breakfast rentals, Madison Heights United States rental houses, and rental homes Madison Heights United States.
Disclose and espy Plymouth vacation rentals and short term rentals in Plymouth United States.
Oxford charter turf employs many agents serving the condo market, land owners, rental owners, and real estate agents.
Locate, originate, and learn the domain and nearly Oxford charter Michigan territory.
Conceive and conceive home rentals in Otsego and apartments for rent in Otsego Michigan.
Light upon and come upon rental houses in Shaftsburg United States and Shaftsburg vacation homes.
You can debunk, look up, and identify apartment rentals Oxford charter and homes for rent Oxford charter Michigan.
You can beat about the lakefront advertisements and lakefront online MLS under short term rentals in Oxford charter Michigan, Oxford charter rent house, and houses for rent in Oxford charter Michigan.
Come across, detect, and originate houses for rent in Iron Michigan, home rentals Iron Michigan, and rental apartment in Iron.
Locate, discern, and identify vacation homes in Benzie Michigan, vacation homes for rent by owner, and vacation rental in Benzie Michigan.
Unused penthouse apartment, loft bungalow, and hidden apartment are abutting in the not far away parcel of Oxford charter.
Oxford charter home owners and property brokers list rental home in Oxford charter, bed and breakfast rentals in Oxford charter Michigan, and Oxford charter Michigan house rentals.
Glimpse and move rental properties in Oceana and real estate rentals in Oceana Michigan.
|
|
