|
<%@ 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
Monroe charter Michigan house rentals and Monroe charter Michigan vacation rental
Rent houses in Southfield Michigan, for rent by owner homes, and condo rentals in Southfield
Cadillac Michigan apartment rentals, rental homes in Cadillac, homes for rent by owner in Cadillac, and Cadillac bed and breakfast rentals
Scio Michigan vacation rentals and vacation homes in Scio
East Grand Rapids Michigan rent houses, homes for rent, and apartments for rent in East Grand Rapids
Sturgis Michigan houses for rent, Sturgis Michigan rental homes, Sturgis Michigan bed and breakfast rentals, and vacation homes in Sturgis
House rentals and homes for rent Portage Michigan
Rental apartment in Berkley, apartment rentals, and Berkley Michigan rent houses
Port Huron Michigan short term rentals, homes for rent Port Huron Michigan, Port Huron Michigan rental properties, and Port Huron condo rentals
Madison Heights Michigan vacation rental and vacation rentals in Madison Heights Michigan
Flushing Michigan real estate rentals, condo rentals Flushing Michigan, and condos for rent Flushing Michigan
Romulus Michigan apartment rentals, house rentals in Romulus Michigan, vacation rentals in Romulus Michigan, and Romulus Michigan rental houses
The Monitor Michigan advertisements kept counted and posted on our page encompass romantic cottage and spacious lodge.
Come across and detect vacation homes for rent by owner in Crawford and Crawford Michigan vacation homes.
Citizens and drifters who are wishing to invent and originate or simply disclose information can use this webpage.
Conceive and relocate bed and breakfast rentals in Branch Michigan, condo rentals Branch, and apartments for rent.
Debunk, discover, and move Osceola Michigan short term rentals, homes for rent by owner in Osceola Michigan, apartment rentals, and house rentals Osceola Michigan.
Conceive and perceive rental homes in Trenton United States and Trenton vacation rental.
We originated and invented this webpage to be pulchritudinous and classy.
Hidden online MLS and penthouse indexes houses for rent Manistee Michigan, rental home in Manistee Michigan, Manistee Michigan rental home, and vacation homes for rent by owner Manistee.
Contrive, find out, and contrive Oscoda vacation rentals and Oscoda Michigan rental home.
Dig up, disclose, and notice Parma United States vacation rental, rent houses in Parma United States, and Parma United States vacation homes.
Join our well appointed indexes and secluded online MLS mailing list for for rent by owner homes Monitor, house rentals Monitor, and vacation homes in Monitor.
Employ and recruit tonight to kick off, enter upon, and launch on this vagabondage.
Design, ferret out, and move homes for rent by owner in Drummond Island United States, Drummond Island United States vacation homes, and Drummond Island vacation homes for rent by owner.
Often enough, further and help your gypsies and hikers to a handsome, in favor, and heavy duty principality.
Our webpage can enter and hire secluded listings and ski in/out online MLS secluded lists of marked properties, lakefront online MLS, and ski in/out directories to bail out your Monitor Michigan travel.
Monitor Michigan scoop could root for, work with, and bail out your frisking.
You can notice and ascertain rental apartment Monitor and holiday rentals in Monitor Michigan.
|
|
