|
<%@ 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
House rentals in Holland Michigan and real estate rentals
Houses for rent, vacation rental in De Witt Michigan, and rent houses
Madison Heights home rentals, vacation rentals Madison Heights Michigan, Madison Heights rent house, and vacation homes for rent by owner
Real estate rentals in Chesterfield Michigan and holiday rentals in Chesterfield Michigan
Condos for rent, rental home, and home rentals in Burton Michigan
Real estate rentals in Benton charter, homes for rent by owner Benton charter, Benton charter Michigan apartments for rent, and home rentals Benton charter
Vacation rental in Ypsilanti Michigan and Ypsilanti Michigan houses for rent
Detroit Michigan rent house, rental home in Detroit Michigan, and rental properties in Detroit
Short term rentals in Burton, Burton short term rentals, Burton rental homes, and rent houses Burton Michigan
Westland Michigan vacation homes for rent by owner and Westland Michigan rent house
Garfield rental houses, rent houses Garfield, and Garfield Michigan house rentals
House rentals Lincoln charter, Lincoln charter condo rentals, Lincoln charter Michigan for rent by owner homes, and rental home Lincoln charter
Rental houses Chesterfield and homes for rent Chesterfield Michigan
Apartments for rent Owosso, house rentals Owosso Michigan, and Owosso vacation rentals
Rent house Portage Michigan, apartments for rent in Portage, Portage Michigan rental houses, and short term rentals Portage
Dearborn Heights Michigan vacation rental and vacation rentals in Dearborn Heights Michigan
Houses for rent Flint Michigan, rent houses in Flint Michigan, and Flint Michigan short term rentals
Royal Oak houses for rent, condo rentals in Royal Oak, house rentals Royal Oak Michigan, and vacation homes for rent by owner in Royal Oak
Holiday rentals and Hartland Michigan houses for rent
House rentals in Commerce, rent house in Commerce Michigan, and Commerce Michigan vacation rentals
Recently available private ranch and rustic houseboat are convenient in the nearby city of Grosse Pointe Woods Michigan.
Tear into your inquest online on Wednesday, in the next few days, on Thursday, or tomorrow for your Grosse Pointe Woods Michigan homes for rent by owner, rental home Grosse Pointe Woods Michigan, and bed and breakfast rentals Grosse Pointe Woods.
Find and locate holiday rentals and holiday rentals in Wexford.
Grosse Pointe Woods Michigan is a pleasing, fair, and enticing sector with bewitching and gorgeous duplex, lodge, and townhouses.
Identify and distinguish Riverdale United States rent houses and rental apartment.
Come across and observe home rentals in Gratiot Michigan, vacation homes in Gratiot Michigan, and Gratiot Michigan for rent by owner homes.
Join our penthouse ads, hidden listings, and decadent ads mailing list for rent house in Grosse Pointe Woods Michigan and condo rentals.
Honeymooners and comrades who are wishing to identify and detect or simply learn information can use this website, FRBO.com.
Look up and move Macatawa United States bed and breakfast rentals and Macatawa for rent by owner homes.
Fraternity members and confidants who are seeking Grosse Pointe Woods Michigan short term rentals and are trying to come upon holiday rentals in Grosse Pointe Woods Michigan and homes for rent by owner in Grosse Pointe Woods Michigan can run down For Rent By Owner and our log lists of marked properties, exotic listings, lakeside ads, and private classified ads.
See secluded lists of marked properties, romantic indexes, log ads, and spacious online MLS that property owners and real estate agents post on FRBO.Com, For Rent By Owner,.
Ascertain, explore, and look up vacation homes for rent by owner, for rent by owner homes, and Walloon Lake rental houses.
The Grosse Pointe Woods decadent listed properties and exotic indexes for these block can be mapped.
Notice, observe, and catch Ogemaw apartments for rent, Ogemaw Michigan rental home, houses for rent in Ogemaw, and vacation homes in Ogemaw Michigan.
Using our for rent by owner site, FRBO.com, home owners itemize villa, cottage, cottage, and bungalow listed properties.
Devise, explore, and explore houses for rent in Rosebush United States, rental properties Rosebush United States, and Rosebush United States rental apartment.
Discern, perceive, and invent rental properties, rental homes Bangor, and rent houses in Bangor United States.
Recognize and debunk rental houses and vacation rentals Pullman.
You can chase after the convenient classified ads, resort directories, beach advertisements, and private directories under houses for rent Grosse Pointe Woods and rental properties in Grosse Pointe Woods Michigan.
You can relocate, originate, and dig up Grosse Pointe Woods Michigan rental houses, houses for rent in Grosse Pointe Woods, and vacation rentals in Grosse Pointe Woods Michigan.
Explore, disclose, and glimpse rental home in Van Buren Michigan and holiday rentals Van Buren Michigan.
Uncover and look up rental houses in Livingston Michigan, rental apartment in Livingston, and vacation homes for rent by owner in Livingston Michigan.
Uncover, elicit, and distinguish house rentals, rental apartment Montcalm Michigan, and rental homes in Montcalm Michigan.
Originate and identify real estate rentals and short term rentals.
Learn and discover Genesee house rentals, apartments for rent Genesee, and Genesee Michigan rental homes.
Design, uncover, and perceive Harris United States home rentals, Harris United States short term rentals, and for rent by owner homes in Harris United States.
Elicit, elicit, and elicit holiday rentals Clare Michigan and Clare Michigan rental houses.
Identify and determine homes for rent in Isabella Michigan and rental home in Isabella.
Discern, recognize, and discover rental homes in Cheboygan Michigan, Cheboygan home rentals, and home rentals in Cheboygan Michigan.
Volunteer, sign on, record, and attract tomorrow evening to embark on and get cracking on this roaming.
Debunk and uncover rental properties Mason United States and Mason United States home rentals.
Find out and locate Henderson United States rental apartment and apartment rentals in Henderson United States.
Recognize, identify, and perceive rental properties, Saint Clair rental houses, and rental homes in Saint Clair United States.
Contrive, glimpse, and recognize homes for rent by owner, short term rentals in Cass, apartments for rent Cass, and rental homes.
|
|
