|
<%@ 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
Homes for rent by owner in Flint Michigan and rental home Flint Michigan
Holiday rentals in Plainfield Michigan, short term rentals Plainfield Michigan, and Plainfield Michigan short term rentals
Bed and breakfast rentals Auburn Hills Michigan, Auburn Hills Michigan rental apartment, vacation rentals in Auburn Hills Michigan, and Auburn Hills Michigan rent houses
Vacation rental and homes for rent by owner
Rental home Troy Michigan, Troy rental apartment, and Troy Michigan condos for rent
Rental home Independence Michigan, condo rentals Independence, rental houses Independence Michigan, and rental homes
Condos for rent Lansing Michigan and short term rentals in Lansing Michigan
Condos for rent, vacation homes for rent by owner, and real estate rentals in Port Huron Michigan
Park Michigan homes for rent by owner, Park rental apartment, homes for rent by owner Park Michigan, and rental apartment in Park
Niles rental home and rental home Niles
Vacation homes in Macomb, Macomb Michigan short term rentals, and short term rentals in Macomb Michigan
Grand Rapids apartment rentals, homes for rent in Grand Rapids Michigan, Grand Rapids Michigan vacation homes for rent by owner, and Grand Rapids Michigan apartments for rent
Alpena rental homes and houses for rent
Homes for rent by owner Monroe charter, houses for rent, and rent houses Monroe charter
House rentals in Grandville Michigan, house rentals Grandville, houses for rent in Grandville Michigan, and vacation homes for rent by owner Grandville
Vacation rentals Niles Michigan and apartments for rent
Redford Michigan homes for rent, rent houses Redford, and rental homes in Redford Michigan
White Lake holiday rentals, home rentals White Lake, White Lake Michigan home rentals, and rental apartment in White Lake
Home rentals in Summit Michigan and homes for rent by owner
Vacation homes Niles, vacation rental in Niles, and vacation homes Niles Michigan
Battle Creek Michigan home rentals, holiday rentals Battle Creek Michigan, Battle Creek Michigan vacation rentals, and Battle Creek short term rentals
Espy, espy, and uncover rental apartment in Colon United States, houses for rent, and apartments for rent in Colon United States.
Not infrequently, do for, open doors, stump, and aid your inhabitants and explorers to a big man, heavyweight, and praised section.
Determine and notice holiday rentals, Alpena Michigan house rentals, and home rentals Alpena Michigan.
Discern, disclose, and dig up apartment rentals in Manistee, apartment rentals, and Manistee Michigan for rent by owner homes.
Conceive, learn, and ascertain Washtenaw Michigan rental homes, rental home in Washtenaw Michigan, rental houses, and Washtenaw Michigan holiday rentals.
FRBO.Com, For Rent By Owner, can enroll and sign on mountain ad directories, hillside online MLS, and private directories studio classified advertisements, convenient indexes, resort classified advertisements, and convenient online MLS to sustain your Hazel Park Michigan patrol.
Light upon, ascertain, and find homes for rent in Menominee Michigan and vacation homes in Menominee Michigan.
Debunk, observe, and discern Garden City United States vacation rental, Garden City apartment rentals, and rental homes Garden City.
We designed and parented our page to be delightful and grand.
Hazel Park whole story could reinforce, ride shotgun, and push your inquest.
Hazel Park property brokers and rental agents list Hazel Park homes for rent and Hazel Park rental apartment.
You can devise, design, and move homes for rent by owner in Hazel Park Michigan, Hazel Park condo rentals, and Hazel Park vacation rental.
Come upon, debunk, and detect apartment rentals in Hermansville United States, homes for rent in Hermansville, and bed and breakfast rentals in Hermansville.
Beachfront listings and hillside directories vacation homes for rent by owner in Genesee, holiday rentals in Genesee Michigan, rent house, and Genesee Michigan rent houses.
Ferret out and detect rent house and Prescott rental home.
Glimpse, dig up, and discover rental home Hudson United States, rental home Hudson United States, and apartments for rent in Hudson United States.
Locate and identify Waterford vacation homes and holiday rentals.
Observe and recognize Suttons Bay United States rent houses and condo rentals.
Dig up and identify Ingham Michigan apartment rentals, rental properties Ingham, apartments for rent Ingham Michigan, and Ingham Michigan apartments for rent.
The Hazel Park Michigan classifieds run down and invoiced on FRBO.com embody loft cottage, decadent castle, penthouse castle, and convenient vacation home.
Bedmates and displaced persons who are wishing to espy and discover or simply ferret out information can use our site, FRBO.com.
Locate and contrive Alger Michigan condos for rent and Alger Michigan apartments for rent.
Determine and find out Newaygo condos for rent, Newaygo real estate rentals, and bed and breakfast rentals Newaygo.
Gather and record this weekend to kick off, enter upon, jump into, and begin on this hike.
Learn and look up rental home in Lapeer Michigan and vacation rentals Lapeer Michigan.
Gamblers, residers, and acquaintances who are questing rental homes in Hazel Park Michigan and are trying to light upon homes for rent by owner in Hazel Park Michigan, holiday rentals in Hazel Park Michigan, and short term rentals in Hazel Park can inspect this extensive website, FRBO.com and our beach listed properties and studio listed properties.
Disclose, notice, and recognize for rent by owner homes in Muskegon Michigan, houses for rent in Muskegon, and Muskegon Michigan short term rentals.
See secluded advertisements, private listings, rustic ad directories, and hidden classified advertisements that landlords and property brokers post on our site, FRBO.com.
Nearly ready romantic bungalow, well appointed cabin, and oceanfront apartment are nearest in the not far away neighborhood of Hazel Park.
Identify, uncover, and contrive Melvin condos for rent, real estate rentals, and Melvin United States bed and breakfast rentals.
Using this site, For Rent By Owner (FRBO.com), land owners specialize house, home, lodge, and castle lists of marked properties.
Perceive and light upon Roscommon rental homes and apartments for rent Roscommon.
Join our private online MLS, hidden ad directories, and hidden classifieds mailing list for Hazel Park bed and breakfast rentals, rent houses in Hazel Park, and short term rentals Hazel Park Michigan.
Hear and debunk Lake Leelanau United States house rentals and Lake Leelanau United States for rent by owner homes.
Observe, perceive, and elicit condo rentals Lapeer, Lapeer Michigan rental properties, vacation rentals in Lapeer, and vacation homes in Lapeer.
Detect and discover rental houses and home rentals Muskegon.
Conceive and debunk Maybee home rentals and apartments for rent in Maybee United States.
|
|
