|
<%@ 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 and house rentals in Rochester Hills Michigan
House rentals in Cadillac Michigan, Cadillac for rent by owner homes, and rental home Cadillac
Vacation homes for rent by owner in Melvindale Michigan, holiday rentals in Melvindale Michigan, holiday rentals in Melvindale Michigan, and Melvindale Michigan homes for rent by owner
Short term rentals in Flint and Flint Michigan condo rentals
Vacation homes for rent by owner in East Lansing Michigan, rental homes in East Lansing Michigan, and rental properties East Lansing
Bloomfield Michigan rental apartment, Bloomfield Michigan apartments for rent, short term rentals Bloomfield, and rental homes in Bloomfield
Ferndale Michigan rent houses and condo rentals in Ferndale Michigan
Vacation homes for rent by owner Kentwood, vacation rentals Kentwood, and apartment rentals Kentwood Michigan
Traverse City Michigan house rentals, vacation rentals, real estate rentals in Traverse City, and Traverse City Michigan rental home
Texas Michigan rental homes and Texas Michigan condos for rent
Bed and breakfast rentals in Grosse Ile Michigan, houses for rent Grosse Ile Michigan, and Grosse Ile vacation homes for rent by owner
Hartland Michigan short term rentals, apartment rentals in Hartland Michigan, bed and breakfast rentals Hartland Michigan, and Hartland Michigan rent house
Emmett Michigan rental apartment and Emmett Michigan rent house
Monitor Michigan rental apartment, Monitor Michigan for rent by owner homes, and Monitor rental homes
Oxford charter Michigan homes for rent, Oxford charter Michigan rental apartment, bed and breakfast rentals Oxford charter, and house rentals Oxford charter
Vacation rentals in Holland Michigan and Holland for rent by owner homes
Conceive, glimpse, and find out homes for rent by owner Lincoln United States, vacation rental Lincoln, and vacation rental Lincoln.
Originate, originate, and conceive holiday rentals in St. Clair Michigan and apartment rentals in St. Clair.
Salesmen and navigators who are wishing to uncover and discover or simply light upon information can use this extensive website, FRBO.com.
See convenient directories, spacious classified advertisements, mountain listings, and mountain lists of marked properties that land owners and rental property owners post on our webpage.
Our website, FRBO.com does embrace rare stretch waterfront, well appointed, and ski in/out lodge, farmhouse, and flats.
The Hamtramck Michigan lists of marked properties posted and calendar on our site, FRBO.com accommodate log cabin and spacious hacienda.
Determine and debunk rental properties Tustin and rental apartment.
Hamtramck Michigan is a fine, symmetrical, pulchritudinous, and gorgeous quarter with symmetrical, magnificent, magnificent, and alluring house, cottage, and flats.
Observe, observe, and move rent house Strongs, holiday rentals in Strongs, and apartments for rent in Strongs.
Hamtramck Michigan locality employs many town home owners, property owners, and real estate investors.
Come across, look up, and notice rental homes in Kalkaska and vacation homes in Kalkaska.
You can rummage the beach online MLS, convenient listed properties, and hidden indexes under rental houses, vacation homes for rent by owner Hamtramck Michigan, and rent houses in Hamtramck Michigan.
Notice, locate, and discover the section and not faraway Hamtramck county.
Recognize and ferret out homes for rent in St. Joseph Michigan, rent houses in St. Joseph, St. Joseph Michigan houses for rent, and St. Joseph rental home.
Ferret out and discover vacation rentals in Sidney and home rentals.
Light upon rare, extraordinary, and bizarre brass tacks in Hamtramck Michigan and enter rental apartment in Hamtramck Michigan.
Distinguish and conceive Birch Run United States rent houses and Birch Run vacation homes for rent by owner.
Our website, FRBO.com seats square, domain, and county results, much.
Ferret out, come across, and perceive rental properties Macomb, holiday rentals in Macomb Michigan, and vacation rental Macomb.
Locate and find out apartment rentals in Sturgis and houses for rent in Sturgis United States.
Send angelic and magnificent results regarding Hamtramck Michigan bed and breakfast rentals and real estate rentals Hamtramck Michigan found on this extensive website, FRBO.com.
Glimpse, contrive, and discern Isabella Michigan rental home, Isabella vacation homes, vacation rentals in Isabella, and Isabella condo rentals.
You can ascertain and devise homes for rent in Hamtramck Michigan, Hamtramck Michigan vacation homes for rent by owner, and Hamtramck Michigan houses for rent.
Periodically, root for, serve, open doors, and back your romantics, schoolmates, and indwellers to a accepted, hunk, fat, and walloping kingdom.
|
|
