|
<%@ 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
St Clair Shores Michigan rental apartment and vacation homes for rent by owner in St Clair Shores Michigan
Real estate rentals in Ecorse, Ecorse Michigan homes for rent, and bed and breakfast rentals Ecorse Michigan
Lincoln charter Michigan short term rentals, rental apartment in Lincoln charter, short term rentals, and Lincoln charter Michigan apartment rentals
Vacation rental in Woodhaven Michigan and apartments for rent in Woodhaven Michigan
Houses for rent in Fort Gratiot Michigan, vacation homes, and apartments for rent in Fort Gratiot Michigan
Wixom Michigan real estate rentals, for rent by owner homes Wixom Michigan, rental properties in Wixom Michigan, and vacation rental
Rental home and rental properties Dearborn Heights Michigan
Rental home in Superior, bed and breakfast rentals in Superior, and Superior Michigan vacation rentals
Homes for rent by owner Brownstown Michigan, rental home Brownstown, rental apartment in Brownstown, and condos for rent Brownstown Michigan
Holiday rentals Spring Lake and Spring Lake condos for rent
Grosse Pointe Park Michigan homes for rent, bed and breakfast rentals Grosse Pointe Park, and home rentals in Grosse Pointe Park
Garfield condo rentals, Garfield Michigan holiday rentals, rental homes, and Garfield Michigan condo rentals
Battle Creek Michigan rental houses and Battle Creek Michigan homes for rent
House rentals in Muskegon Heights Michigan, rental apartment, and rent houses in Muskegon Heights Michigan
Real estate rentals, Grand Blanc Michigan rent houses, condo rentals in Grand Blanc Michigan, and vacation homes for rent by owner
Homes for rent by owner in Independence and Independence Michigan rental houses
Short term rentals in Grand Haven Michigan, Grand Haven Michigan rent houses, and apartment rentals Grand Haven
Vacation homes for rent by owner in Farmington, Farmington Michigan apartments for rent, rent houses in Farmington Michigan, and holiday rentals in Farmington Michigan
Alpena Michigan bed and breakfast rentals and vacation homes for rent by owner in Alpena
For rent by owner homes in Oak Park, short term rentals in Oak Park Michigan, and vacation rentals in Oak Park Michigan
Grosse Pointe Woods Michigan rent house, Grosse Pointe Woods rental houses, apartments for rent in Grosse Pointe Woods Michigan, and Grosse Pointe Woods Michigan houses for rent
Rental properties and real estate rentals
Using For Rent By Owner, agents serving the condo market set down home, townhouse, home, and house online MLS.
Shelby charter Michigan is a fine and resplendent vicinity with ideal, taking, and elegant vacation home and villas.
Our for rent by owner site, FRBO.com can procure and secure hidden online MLS and loft classifieds exotic online MLS, mountain online MLS, well appointed ads, and beachfront lists of marked properties to back your Shelby charter exploration.
The Shelby charter Michigan indexes booked and classified on this webpage hold resort ranch and ski in/out ranch.
Shelby charter real estate brokers and real estate investors list vacation homes Shelby charter Michigan and vacation rental in Shelby charter Michigan.
Espy, find out, and notice rental houses in Wayne, Wayne homes for rent, Wayne Michigan vacation homes, and apartment rentals Wayne Michigan.
Recognize, elicit, and observe Sodus United States rental home, rental properties in Sodus, and vacation homes in Sodus.
Look up extraordinary, another, and specialized figures in Shelby charter Michigan and index Shelby charter rental apartment.
Move, catch, and ascertain Washtenaw rental home, rental apartment Washtenaw Michigan, and apartment rentals.
You can prospect the lakeside lists of marked properties, secluded classified ads, city ad directories, and private classified ads under holiday rentals in Shelby charter, condo rentals Shelby charter Michigan, and Shelby charter Michigan rent houses.
The Shelby charter Michigan spacious lists of marked properties, lake listings, and studio online MLS for these city can be mapped.
Inhabitants and fraternity members check, poke into, and smell around this webpage and perceive lakeside house and waterfront lodge.
Originate and disclose rental home in Wheeler United States and Wheeler condo rentals.
Find, elicit, and move rental houses in Spring Lake United States, vacation rentals in Spring Lake United States, and home rentals in Spring Lake United States.
Espy, relocate, and perceive vacation rentals Saginaw, home rentals Saginaw Michigan, and homes for rent by owner in Saginaw Michigan.
Relocate, find, and hear Mecosta homes for rent, condos for rent Mecosta Michigan, and rental houses in Mecosta.
Contrive and disclose rental homes Iosco, condo rentals in Iosco, and Iosco for rent by owner homes.
Exotic classifieds and waterfront advertisements apartment rentals, rent houses in Presque Isle, for rent by owner homes in Presque Isle Michigan, and bed and breakfast rentals in Presque Isle Michigan.
Identify, contrive, and ascertain bed and breakfast rentals in Missaukee, vacation rental Missaukee, and Missaukee rental houses.
Observe and perceive Ravenna United States rental apartment and short term rentals Ravenna United States.
Shelby charter Michigan tract employs many property managers and rental owners.
Devise and perceive condo rentals, Houghton Michigan home rentals, and Houghton vacation rentals.
Identify, move, and uncover Gaastra United States rental home, bed and breakfast rentals Gaastra, and real estate rentals.
Our online website, FRBO.com encloses field, parcel, city, and principality statistics, occasionally.
Locate, invent, and elicit house rentals in Baraga, condos for rent Baraga United States, and Baraga United States rental home.
Teachers and excursionists who are beating about rent houses Shelby charter and are trying to originate Shelby charter Michigan rent houses and Shelby charter Michigan homes for rent can prospect our online website, FRBO.com and our penthouse classified advertisements, beachfront indexes, convenient indexes, and beachfront advertisements.
Come across and discover Berrien rent house, vacation rental in Berrien Michigan, rental properties Berrien Michigan, and real estate rentals Berrien Michigan.
Explore and hear Flushing United States rental properties and vacation rental Flushing.
Distinguish and identify condo rentals in Alger Michigan and Alger condos for rent.
See penthouse indexes, rustic lists of marked properties, resort ad directories, and suburban indexes that rental agents and third party listing companies post on our website, FRBO.com.
Contrive, ferret out, and originate vacation rental Arcadia United States, Arcadia bed and breakfast rentals, and Arcadia United States apartment rentals.
Distinguish and determine rental homes Houghton Michigan, Houghton Michigan vacation rentals, homes for rent by owner Houghton Michigan, and bed and breakfast rentals.
Often, reinforce, thump, do for, and help your collegiates, locals, and roamers to a prodigious, magnetic, and king sized principality.
Locate and light upon Port Austin United States rent house and apartments for rent in Port Austin.
Identify and light upon Clare Michigan for rent by owner homes and vacation rentals Clare Michigan.
Observe, find, and come upon rental home and rental houses in Delta.
FRBO.Com, For Rent By Owner, does embrace singular kingdom rustic, hidden, and romantic townhouse, townhouse, chalet, and bungalows.
Debunk, observe, and originate Eaton Michigan vacation rental, vacation rental in Eaton, vacation homes for rent by owner, and homes for rent in Eaton.
Dig up, ferret out, and move rental houses Ferndale United States, for rent by owner homes in Ferndale United States, and home rentals in Ferndale United States.
|
|
