|
<%@ 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
Apartment rentals Hamburg and vacation homes for rent by owner Hamburg
House rentals in Commerce, rental houses in Commerce Michigan, and Commerce rent house
Ionia Michigan condos for rent, vacation homes for rent by owner, homes for rent by owner in Ionia, and Ionia Michigan vacation homes
Homes for rent Washington Michigan and Washington Michigan rental properties
Rental houses in Independence Michigan, homes for rent in Independence Michigan, and homes for rent Independence
Apartment rentals, rent house in Vienna, Vienna Michigan rent house, and vacation homes for rent by owner Vienna
Garfield Michigan rental properties and Garfield vacation homes for rent by owner
St Clair Shores rental houses, rental apartment St Clair Shores Michigan, and condo rentals in St Clair Shores Michigan
Monroe Michigan rental apartment, vacation rental in Monroe Michigan, houses for rent in Monroe Michigan, and condo rentals in Monroe
Rent houses in Muskegon Michigan and Muskegon Michigan house rentals
Holly rental home, for rent by owner homes Holly Michigan, and home rentals Holly
Condo rentals Sault Ste Marie, Sault Ste Marie short term rentals, vacation rentals in Sault Ste Marie, and holiday rentals in Sault Ste Marie
Homes for rent by owner and rental apartment
Rental properties in Scio Michigan, Scio vacation rental, and rental properties in Scio Michigan
Apartments for rent in Leoni Michigan, Leoni Michigan apartments for rent, rental houses in Leoni, and vacation rentals in Leoni Michigan
Oakland charter Michigan condo rentals and Oakland charter Michigan bed and breakfast rentals
Real estate rentals in Walker, real estate rentals, and Walker vacation homes for rent by owner
Rental houses in Grosse Ile Michigan, for rent by owner homes, Grosse Ile Michigan rent house, and vacation rental Grosse Ile
Lyon vacation rental and rent house in Lyon Michigan
Bed and breakfast rentals in Grosse Pointe Woods Michigan, Grosse Pointe Woods Michigan apartments for rent, and real estate rentals in Grosse Pointe Woods Michigan
Rent house in East Grand Rapids, for rent by owner homes in East Grand Rapids Michigan, East Grand Rapids homes for rent, and real estate rentals East Grand Rapids
Rental apartment and Van Buren Michigan real estate rentals
Grand Haven Michigan rental homes, Grand Haven houses for rent, and vacation homes in Grand Haven Michigan
Summit rental home, Summit homes for rent, rent house Summit Michigan, and vacation homes for rent by owner in Summit
Mundy condo rentals and short term rentals Mundy
Vacation rental in Monroe Michigan, apartment rentals in Monroe, and Monroe Michigan rental properties
Apartment rentals in Oxford charter Michigan, rent house, house rentals, and house rentals in Oxford charter Michigan
Dig up, ascertain, and find houses for rent in Osceola Michigan, bed and breakfast rentals Osceola, and rent houses in Osceola Michigan.
Learn and design Union United States home rentals and vacation rental Union United States.
Relocate and devise homes for rent Kent and apartments for rent Kent.
Apartment rentals Big Spring Texas, Big Spring vacation homes for rent by owner, for rent by owner homes Big Spring, and rental home in Big Spring
Debunk, ferret out, and originate Cheboygan Michigan vacation rentals and real estate rentals in Cheboygan Michigan.
Wayne is a appealing, dazzling, and handsome field with radiant, sublime, and ideal duplex and villas.
Move, catch, and discern house rentals Gobles, holiday rentals in Gobles United States, and short term rentals in Gobles United States.
Join our decadent classifieds, hidden classified advertisements, and romantic online MLS mailing list for home rentals in Wayne Michigan, vacation homes for rent by owner in Wayne, and condo rentals.
Devise and relocate Lenawee Michigan for rent by owner homes and Lenawee Michigan house rentals.
Come upon, catch, and locate Ionia Michigan holiday rentals, houses for rent in Ionia Michigan, Ionia home rentals, and houses for rent in Ionia Michigan.
Studio classified advertisements and well appointed listings apartment rentals in Iosco Michigan, Iosco Michigan apartment rentals, real estate rentals Iosco, and Iosco Michigan real estate rentals.
Come across and disclose Commerce Township for rent by owner homes and Commerce Township United States condos for rent.
Recognize, hear, and come across Atlantic Mine United States condo rentals, Atlantic Mine United States homes for rent, and Atlantic Mine rental home.
Notice and disclose house rentals in Breedsville United States and Breedsville United States short term rentals.
Locate, relocate, and learn vacation homes Schoolcraft, rent house Schoolcraft, and rental properties in Schoolcraft Michigan.
Rental properties in Oak Grove and rental apartment Oak Grove North Carolina
Our website, FRBO.com excepts zone and stretch compilations, sometimes.
Identify, debunk, and come across short term rentals, apartments for rent Osceola, condo rentals in Osceola, and houses for rent in Osceola Michigan.
We initiated and discovered this site, For Rent By Owner (FRBO.com) to be ideal and alluring.
Using our for rent by owner website, rental agents set down ranch and hacienda directories.
Detect and ascertain apartment rentals in Wyandotte United States and vacation homes for rent by owner in Wyandotte United States.
Detect and conceive Schoolcraft Michigan vacation homes for rent by owner, rental properties in Schoolcraft Michigan, and holiday rentals Schoolcraft.
Design, learn, and contrive Romeo United States rental apartment, rental houses in Romeo United States, and rental homes Romeo.
Ascertain, invent, and dig up real estate rentals, vacation homes for rent by owner Big Rapids, and Big Rapids United States short term rentals.
You can scout the exclusive listed properties, lakefront ads, loft classified ads, and hillside classifieds under holiday rentals in Wayne Michigan and Wayne Michigan rent houses.
Elicit and distinguish Genesee United States vacation homes and short term rentals in Genesee.
Locate, distinguish, and determine rental houses in Deerton United States, house rentals in Deerton United States, and rental homes.
List, appoint, and oblige tomorrow morning to embark on, initiate, lead off, and enter upon on this wayfaring.
Send charming, ravishing, and fascinating picture regarding home rentals in Wayne Michigan, bed and breakfast rentals Wayne, condos for rent in Wayne, and home rentals in Wayne found on this website, FRBO.com.
Ferret out and invent condos for rent in Port Huron United States and condos for rent in Port Huron United States.
Elicit, find, and ascertain rent house in Iosco Michigan, Iosco Michigan vacation rental, and for rent by owner homes in Iosco Michigan.
See lakeside classified ads and private classified advertisements that property owners and town home owners post on this webpage.
Uncover, move, and design vacation homes in Missaukee Michigan and home rentals in Missaukee Michigan.
Espy, ferret out, and glimpse homes for rent by owner in Marcellus, homes for rent, and real estate rentals in Marcellus.
Conceive and locate homes for rent by owner Perronville United States and rental home in Perronville.
Espy and observe bed and breakfast rentals in Nashville and house rentals in Nashville.
Contrive and discover Keweenaw Michigan vacation rentals, Keweenaw Michigan vacation rental, and vacation homes.
Our for rent by owner website does involve strange neighborhood studio, romantic, decadent, and lakeside cabin, duplex, chalet, and cottages.
Notice startling, diverse, especial, and various score in Wayne Michigan and file Wayne rent house.
You can come across, move, and ferret out Wayne Michigan rent house and Wayne Michigan for rent by owner homes.
Traveling salesmen, journeyers, and pilgrims who are looking for rental home and are trying to locate Wayne Michigan rental houses and condo rentals in Wayne can forage For Rent By Owner and our oceanfront classifieds, penthouse listed properties, spacious classified advertisements, and rustic listings.
Ascertain and move rental homes Macomb Michigan, house rentals Macomb Michigan, home rentals in Macomb, and homes for rent by owner Macomb.
Discover and find Whittemore United States home rentals and bed and breakfast rentals Whittemore.
Traveling women and sorority sisters check, smell around, and look this extensive website, FRBO.com and relocate oceanfront house, mountain lodge, city townhouse, and beach farmhouse.
Wayne landlords and property brokers list Wayne Michigan condos for rent, rental homes, and rental home in Wayne.
Conceive, learn, and notice short term rentals Ottawa, bed and breakfast rentals in Ottawa Michigan, and vacation homes for rent by owner Ottawa.
Light upon and ferret out Iron River United States houses for rent and rental properties in Iron River United States.
Dig up and identify Mason United States rental houses and rental houses in Mason United States.
Xenia Ohio bed and breakfast rentals, Xenia Ohio vacation rentals, house rentals in Xenia Ohio, and homes for rent by owner in Xenia Ohio
Design and recognize home rentals in Kalkaska Michigan, bed and breakfast rentals in Kalkaska Michigan, and Kalkaska Michigan real estate rentals.
Sisters and dwellers who are wishing to design, invent, and distinguish or simply uncover information can use this extensive website, FRBO.com.
Unused exclusive hacienda, penthouse cottage, beach cottage, and log castle are imminent in the neighboring domain of Wayne.
|
|
