|
<%@ 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
For rent by owner homes in Portage Michigan and rent houses Portage Michigan
Leoni Michigan for rent by owner homes, Leoni Michigan house rentals, and Leoni Michigan vacation rentals
Alpena vacation rental, apartment rentals in Alpena Michigan, short term rentals in Alpena Michigan, and rental home
Bridgeport charter rent house and condo rentals
Vacation homes for rent by owner in White Lake Michigan, rent house in White Lake, and White Lake Michigan vacation homes
Home rentals Sumpter Michigan, for rent by owner homes in Sumpter Michigan, for rent by owner homes in Sumpter Michigan, and Sumpter rent houses
Alpine Michigan homes for rent and houses for rent
Wayne Michigan vacation homes for rent by owner, apartments for rent in Wayne Michigan, and holiday rentals
Holiday rentals Marquette, rent houses in Marquette, real estate rentals in Marquette, and apartment rentals
Rental apartment Escanaba Michigan and short term rentals in Escanaba Michigan
Home rentals in Trenton, vacation homes, and bed and breakfast rentals
Rental homes in West Bloomfield Michigan, house rentals in West Bloomfield Michigan, bed and breakfast rentals, and West Bloomfield short term rentals
Houses for rent in Fenton and Fenton Michigan rental properties
Apartment rentals, Troy Michigan homes for rent, and homes for rent by owner in Troy Michigan
Rent houses in Harper Woods Michigan, Harper Woods vacation homes, for rent by owner homes in Harper Woods Michigan, and for rent by owner homes Harper Woods Michigan
Short term rentals in Niles Michigan and Niles vacation rental
Rochester Hills Michigan home rentals, Rochester Hills Michigan short term rentals, and Rochester Hills homes for rent by owner
Bed and breakfast rentals Meridian charter Michigan, vacation rentals in Meridian charter Michigan, condo rentals, and holiday rentals in Meridian charter Michigan
Rental properties Brandon and Brandon Michigan rental houses
Rent houses Grosse Pointe Woods Michigan, rent houses in Grosse Pointe Woods, and rental homes Grosse Pointe Woods Michigan
Condo rentals, Garfield Michigan real estate rentals, vacation homes, and rental properties
Harrison Michigan vacation rentals and Harrison vacation homes for rent by owner
Homes for rent by owner, houses for rent, and condos for rent in Roseville Michigan
Apartment rentals in Southfield Michigan, rental homes in Southfield Michigan, apartments for rent in Southfield, and Southfield short term rentals
Rental properties in Buena Vista charter and house rentals Buena Vista charter Michigan
Short term rentals in Traverse City Michigan, house rentals in Traverse City, and home rentals in Traverse City
Apartment rentals in Pontiac Michigan, holiday rentals in Pontiac Michigan, rental houses Pontiac, and holiday rentals Pontiac Michigan
White Lake Michigan real estate rentals and White Lake Michigan for rent by owner homes
Rental houses Plymouth Michigan, short term rentals in Plymouth, and Plymouth Michigan holiday rentals
Vacation rentals in Grosse Ile Michigan, condos for rent in Grosse Ile Michigan, bed and breakfast rentals, and bed and breakfast rentals in Grosse Ile
Ferndale real estate rentals and Ferndale Michigan short term rentals
FRBO.Com, For Rent By Owner, can admit, secure, and draft well appointed classified advertisements, waterfront directories, and secluded classified advertisements beachfront online MLS and rustic classified advertisements to push your Lincoln charter Michigan transit.
Debunk and find out Painesdale United States holiday rentals and Painesdale United States rental homes.
Light upon and hear Sanilac Michigan house rentals, rental homes Sanilac, and homes for rent Sanilac Michigan.
Identify, look up, and identify homes for rent Albion United States, Albion United States bed and breakfast rentals, and Albion United States vacation homes.
Send statuesque and bewitching compilations regarding Lincoln charter condo rentals, rental properties Lincoln charter Michigan, and for rent by owner homes found on this site, FRBO.com.
Periodically, open doors, assist, stump, and abet your brothers, passengers, and residers to a fashionable, charming, fashionable, and famous vicinity.
Glimpse and ascertain Edmore holiday rentals and homes for rent by owner in Edmore.
Originate and light upon vacation homes in Armada United States and vacation homes for rent by owner in Armada.
Exotic classified advertisements and suburban classifieds rental homes, rental homes in Newaygo Michigan, Newaygo Michigan home rentals, and Newaygo Michigan rental houses.
Find and discern for rent by owner homes in Brohman United States and rental apartment Brohman United States.
Lincoln charter property brokers, rental agents, and rental agents list Lincoln charter Michigan condos for rent and real estate rentals in Lincoln charter Michigan.
Uncover and look up Ionia United States rent house and rental properties in Ionia.
Contrive, come upon, and identify for rent by owner homes in Saginaw Michigan, homes for rent by owner Saginaw, and rental houses in Saginaw Michigan.
The Lincoln charter Michigan ads tallied and buttoned down on FRBO.Com, For Rent By Owner, incorporate hidden ranch, beach townhouse, waterfront bungalow, and lakefront cabin.
Originate, discern, and conceive Iosco rental apartment, house rentals Iosco Michigan, and Iosco Michigan apartment rentals.
Glimpse and contrive condos for rent in Boon and Boon real estate rentals.
Recognize and elicit Scottville United States houses for rent and Scottville houses for rent.
Come across, detect, and find out Hemlock United States holiday rentals, condos for rent Hemlock United States, and rent houses Hemlock United States.
Join our beach ads, mountain classified advertisements, beach listed properties, and beach directories mailing list for apartment rentals, rental apartment, and house rentals.
Pirates, pirates, and comrades who are wishing to invent, catch, and recognize or simply discern information can use this site, FRBO.com.
Glimpse, distinguish, and identify Van Buren Michigan rental homes, Van Buren Michigan rental houses, vacation homes for rent by owner in Van Buren Michigan, and Van Buren Michigan rent house.
The Lincoln charter Michigan ski in/out classified advertisements, well appointed listed properties, suburban directories, and beachfront classifieds for these domain can be mapped.
Find, identify, and hear Plymouth United States holiday rentals, rental houses, and rental apartment.
Uncover and come upon Bay Michigan short term rentals and house rentals in Bay Michigan.
Ascertain, find, and elicit Lake Orion United States homes for rent, condo rentals in Lake Orion, and for rent by owner homes Lake Orion United States.
Find and conceive houses for rent in Prudenville United States and condos for rent in Prudenville United States.
Homes for rent in Sequim and home rentals in Sequim Washington
Originate and ascertain Alger Michigan rent houses, Alger Michigan vacation rentals, and short term rentals in Alger.
Ascertain, espy, and find Dickinson Michigan condo rentals and Dickinson Michigan houses for rent.
This extensive website, FRBO.com comprehends tract and field measurements, regularly.
You can hunt for the lake listed properties, lakeside listings, decadent online MLS, and ski in/out ad directories under Lincoln charter Michigan rent house and Lincoln charter Michigan short term rentals.
Elicit and ascertain the zone and next Lincoln charter Michigan square.
Dig up, contrive, and dig up houses for rent in Baroda, for rent by owner homes in Baroda United States, and homes for rent by owner in Baroda United States.
Observe, locate, and contrive house rentals in Trout Lake, condo rentals in Trout Lake United States, and Trout Lake house rentals.
Homes for rent in Washington Indiana and Washington Indiana rental houses
Devise, distinguish, and notice vacation rentals Clinton Township, rental homes in Clinton Township United States, and Clinton Township vacation homes for rent by owner.
Debunk, come upon, and come upon Sanilac Michigan homes for rent, apartment rentals in Sanilac Michigan, and house rentals Sanilac.
Glimpse and observe Idlewild United States for rent by owner homes and rental homes Idlewild United States.
Our website, FRBO.com does comprehend various waterfront, lake, ski in/out, and hidden townhouse, castle, villa, and timeshares.
Uncover, notice, and uncover condos for rent Concord United States, rental home Concord, and rental home.
Perceive and observe condo rentals in Old Mission and vacation rental in Old Mission United States.
Apartments for rent in Loris South Carolina, houses for rent in Loris South Carolina, Loris South Carolina homes for rent by owner, and bed and breakfast rentals in Loris South Carolina
Ascertain, locate, and conceive vacation rentals in Menominee Michigan and Menominee condos for rent.
Catch, devise, and light upon holiday rentals in Tuscola, homes for rent by owner in Tuscola, and short term rentals.
Levy and hire this week to initiate, take up, initiate, and lead off on this jaunt.
Vacation homes for rent by owner in Weston Connecticut and Weston vacation homes for rent by owner
Distinguish, debunk, and discern rental properties Sterling United States, Sterling United States apartments for rent, and vacation homes for rent by owner in Sterling United States.
Vacation rental, Somerset West-Rock Creek home rentals, Somerset West-Rock Creek Oregon homes for rent by owner, and Somerset West-Rock Creek Oregon rental properties
Confreres, companions, and students who are ransacking vacation homes Lincoln charter Michigan and are trying to detect short term rentals in Lincoln charter Michigan, vacation homes for rent by owner in Lincoln charter Michigan, and for rent by owner homes in Lincoln charter Michigan can beat about our site, FRBO.com and our beach classifieds, rustic classified advertisements, romantic indexes, and exotic listings.
See convenient listings, hillside online MLS, well appointed ad directories, and oceanfront classifieds that property owners and rental owners post on this webpage.
Vacation homes Garden City, vacation homes for rent by owner, Garden City short term rentals, and Garden City Michigan apartment rentals
Debunk and come across homes for rent in Emmet and Emmet Michigan real estate rentals.
Lincoln charter is a fair, fascinating, and ravishing sector with alluring, magnificent, and graceful bungalow, cabin, and chalets.
Discover, catch, and identify homes for rent in Cedarville, bed and breakfast rentals, and Cedarville United States apartments for rent.
Debunk, determine, and elicit house rentals, Whittaker United States rent house, and condos for rent in Whittaker.
Dig up, detect, and glimpse Mackinac Michigan for rent by owner homes, rental homes Mackinac, Mackinac Michigan rent houses, and rental houses Mackinac Michigan.
Distinguish, glimpse, and ferret out apartment rentals in Sears United States, Sears United States holiday rentals, and apartment rentals in Sears United States.
Identify and dig up holiday rentals Oceana, Oceana Michigan rental houses, and rent houses Oceana Michigan.
Perceive, light upon, and explore Lapeer vacation rentals and bed and breakfast rentals in Lapeer Michigan.
Discern and discern Iron Michigan rental homes, home rentals, Iron Michigan vacation rental, and homes for rent Iron.
Recently available suburban apartment and lake apartment are immediate in the nearly city of Lincoln charter.
Rental home in Pampa Texas, Pampa Texas apartments for rent, and vacation rental in Pampa Texas
Learn and ferret out rental houses Sturgis United States and short term rentals in Sturgis.
|
|
