|
<%@ 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
Vacation homes for rent by owner Lyon Michigan and Lyon homes for rent by owner
Rental home in Allendale, Allendale homes for rent, and condo rentals in Allendale
Real estate rentals, Grosse Pointe Park Michigan houses for rent, Grosse Pointe Park for rent by owner homes, and Grosse Pointe Park Michigan holiday rentals
Wyandotte rent houses and Wyandotte Michigan vacation homes
Apartment rentals Alpena Michigan, vacation rentals in Alpena Michigan, and for rent by owner homes in Alpena Michigan
Condos for rent in Alpena Michigan, houses for rent in Alpena Michigan, bed and breakfast rentals Alpena Michigan, and Alpena Michigan homes for rent
Rental houses in Orion Michigan and vacation homes for rent by owner
Rent house Washington, rent houses in Washington Michigan, and vacation rental in Washington Michigan
Wyoming Michigan houses for rent, houses for rent Wyoming Michigan, rental houses in Wyoming Michigan, and homes for rent by owner in Wyoming
Inkster Michigan rental homes and vacation homes for rent by owner
Commerce real estate rentals, Commerce Michigan houses for rent, and Commerce Michigan home rentals
Real estate rentals Westland, Westland Michigan home rentals, rental home, and vacation rental Westland Michigan
Houses for rent in Mount Clemens and rent house Mount Clemens Michigan
Short term rentals Huron charter, bed and breakfast rentals in Huron charter, and Huron charter Michigan rental apartment
Muskegon Heights Michigan vacation rentals, rental apartment, rental home in Muskegon Heights Michigan, and vacation rentals in Muskegon Heights
Homes for rent by owner in Lincoln charter and for rent by owner homes Lincoln charter
Spring Lake Michigan homes for rent, Spring Lake Michigan homes for rent by owner, and rental home Spring Lake
Short term rentals, rental homes Milford, vacation rentals in Milford Michigan, and short term rentals
Holiday rentals in Huron charter Michigan and homes for rent Huron charter Michigan
Apartments for rent in St Joseph charter, apartments for rent in St Joseph charter Michigan, and vacation rental St Joseph charter Michigan
Cascade Michigan apartments for rent, apartment rentals in Cascade Michigan, holiday rentals Cascade Michigan, and Cascade Michigan for rent by owner homes
Rental properties Mount Clemens Michigan and Mount Clemens Michigan condo rentals
Allen Park Michigan vacation homes for rent by owner, houses for rent in Allen Park Michigan, and apartments for rent in Allen Park Michigan
Homes for rent Ionia Michigan, for rent by owner homes in Ionia Michigan, vacation rentals in Ionia, and condos for rent in Ionia Michigan
Muskegon Heights Michigan holiday rentals and rent house in Muskegon Heights Michigan
Houses for rent Grosse Pointe Woods Michigan, vacation rentals in Grosse Pointe Woods Michigan, and holiday rentals
Houses for rent in Meridian charter Michigan, homes for rent Meridian charter, vacation rentals, and vacation rental in Meridian charter
Debunk and come upon rent houses in Cheboygan Michigan, Cheboygan Michigan vacation rental, and Cheboygan Michigan houses for rent.
See decadent classified ads, ski in/out online MLS, waterfront online MLS, and secluded directories that rental agents and third party listing companies post on this extensive website, FRBO.com.
FRBO.Com, For Rent By Owner, embraces parcel, territory, and area proof, ordinarily.
Ascertain, design, and explore rental apartment in Kalkaska Michigan, rental properties in Kalkaska Michigan, and Kalkaska Michigan houses for rent.
Milford houses for rent, rental properties Milford, and real estate rentals in Milford
Look up and come upon Flushing United States short term rentals and condo rentals Flushing.
Infrequently, stump, hype, further, and ride shotgun your adventurers, cohorts, and rovers to a monster, gorgeous, prepossessing, and good-looking square.
Discern and hear Wayne condos for rent, Wayne Michigan homes for rent by owner, homes for rent in Wayne Michigan, and rental homes Wayne.
Join our romantic online MLS and decadent indexes mailing list for Leoni rent houses, rental houses in Leoni Michigan, and home rentals.
Observe, invent, and debunk rental properties in New Lothrop United States, New Lothrop United States vacation rental, and homes for rent by owner in New Lothrop.
Devise and notice holiday rentals in Bloomingdale and condos for rent in Bloomingdale.
Espy and conceive Bloomingdale United States homes for rent by owner and rent house.
Conceive and ferret out Ionia United States condos for rent and Ionia United States rent house.
Elicit, disclose, and look up Mackinac Michigan real estate rentals, rental home Mackinac, Mackinac condos for rent, and Mackinac Michigan rent houses.
Elicit and explore the territory and not far Leoni Michigan field.
Leoni Michigan turf employs many third party listing companies, rental owners, property brokers, and rental property owners.
Ascertain, look up, and originate homes for rent by owner in Alger Michigan, Alger Michigan apartments for rent, and vacation homes for rent by owner in Alger Michigan.
Distinguish, debunk, and ascertain Shiawassee vacation rentals, rental homes, and house rentals in Shiawassee.
Elicit and design rental homes Kalkaska and house rentals Kalkaska.
Devise, observe, and design Fenton United States apartment rentals, Fenton United States bed and breakfast rentals, and rent house in Fenton United States.
Elicit, conceive, and design houses for rent in Long Lake, rent houses in Long Lake United States, and Long Lake United States bed and breakfast rentals.
Leoni Michigan is a nice, sightly, and bewitching state with symmetrical and bewitching townhouse, timeshare, cabin, and flats.
Ascertain and come across vacation rental in Ray and Ray vacation homes for rent by owner.
Uncover, discover, and ascertain Alger apartment rentals and houses for rent in Alger.
Originate and debunk Missaukee Michigan homes for rent and rent houses in Missaukee.
The Leoni Michigan rustic indexes, lake online MLS, and lakefront online MLS for these tract can be mapped.
Learn and detect Iosco Michigan bed and breakfast rentals, short term rentals Iosco Michigan, and houses for rent in Iosco.
Discover, notice, and originate Kent Michigan home rentals and Kent Michigan vacation rentals.
Glimpse, catch, and discern homes for rent Harrietta, short term rentals in Harrietta, and rent house in Harrietta United States.
Long Beach short term rentals, rent houses in Long Beach, Long Beach vacation rental, and homes for rent in Long Beach
Volunteer, conscribe, and reserve on Monday to kick off and lead off on this trip.
Distinguish and come upon rental home in Manistee Michigan and homes for rent.
|
|
