|
<%@ 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
Rental apartment and Troy Michigan houses for rent
Rent houses, apartments for rent Davison, and vacation homes in Davison Michigan
Ferndale Michigan condos for rent, real estate rentals Ferndale Michigan, vacation rentals Ferndale Michigan, and for rent by owner homes Ferndale
Holiday rentals and vacation homes in Fenton Michigan
Rental apartment in Woodhaven, Woodhaven rental homes, and Woodhaven Michigan rent house
Rent house in Grand Haven Michigan, homes for rent by owner in Grand Haven Michigan, rental houses, and Grand Haven Michigan house rentals
Fraser Michigan for rent by owner homes and house rentals in Fraser Michigan
For rent by owner homes in Melvindale Michigan, Melvindale rental home, and vacation homes in Melvindale Michigan
Grandville rental properties, vacation rental in Grandville, apartments for rent in Grandville Michigan, and rental home
Homes for rent in Grand Haven Michigan and homes for rent by owner in Grand Haven
Lansing Michigan vacation homes for rent by owner, Lansing bed and breakfast rentals, and Lansing vacation rentals
Apartment rentals Scio, Scio Michigan rental apartment, rental houses in Scio, and for rent by owner homes in Scio Michigan
Houses for rent in Grosse Pointe Park and for rent by owner homes in Grosse Pointe Park Michigan
Short term rentals in Midland, rental apartment Midland, and rent house
Rental homes, Wyoming vacation homes for rent by owner, homes for rent by owner in Wyoming Michigan, and apartments for rent
Rent house in Grand Haven Michigan and real estate rentals in Grand Haven Michigan
Benton Harbor Michigan condo rentals, Benton Harbor Michigan vacation rentals, and rent houses
Rochester rental home, vacation homes Rochester Michigan, houses for rent, and for rent by owner homes Rochester
Vacation homes and Farmington Michigan bed and breakfast rentals
Condo rentals Ionia Michigan, Ionia homes for rent, and Ionia rent house
Springfield rental properties, house rentals in Springfield Michigan, rental home in Springfield Michigan, and bed and breakfast rentals Springfield Michigan
Midland Michigan real estate rentals and holiday rentals
Real estate rentals in Orion, houses for rent in Orion, and Orion Michigan rental apartment
Home rentals Mount Clemens, home rentals in Mount Clemens Michigan, vacation rental in Mount Clemens Michigan, and for rent by owner homes in Mount Clemens Michigan
Holiday rentals Allen Park Michigan and rent house
For rent by owner homes in Emmett Michigan, for rent by owner homes in Emmett Michigan, and Emmett Michigan home rentals
Rent houses Ann Arbor Michigan, bed and breakfast rentals in Ann Arbor Michigan, Ann Arbor Michigan rental home, and Ann Arbor Michigan homes for rent
Homes for rent in Milford Michigan and homes for rent Milford Michigan
Rental properties Farmington, homes for rent Farmington, and house rentals Farmington Michigan
Vacation homes Monroe, rental apartment, Monroe Michigan rent house, and apartments for rent
Vacation homes in Lansing Michigan and Lansing vacation homes for rent by owner
Rochester Michigan bed and breakfast rentals, Rochester apartment rentals, and Rochester rent house
Recognize, come across, and ascertain rental houses in Mayville, house rentals, and Mayville apartments for rent.
Detect, determine, and relocate Chippewa condo rentals and Chippewa Michigan vacation homes.
Jet-setters and hikers who are going through Delta charter Michigan house rentals and are trying to recognize Delta charter Michigan vacation rentals, condo rentals in Delta charter, and short term rentals Delta charter Michigan can root this webpage and our spacious online MLS, beach ad directories, suburban ads, and romantic listings.
Explore and discern homes for rent by owner in Flushing United States and home rentals in Flushing.
Devise, originate, and look up rent house, Mackinac Michigan vacation homes for rent by owner, and homes for rent by owner Mackinac Michigan.
Ascertain, contrive, and distinguish rental home Houghton, Houghton Michigan rental homes, and condo rentals in Houghton.
Delta charter land owners, rental agents, property owners, and land owners list Delta charter Michigan bed and breakfast rentals, vacation homes Delta charter Michigan, rental homes Delta charter Michigan, and apartments for rent in Delta charter.
Notice, ferret out, and elicit Houghton Michigan condo rentals and homes for rent in Houghton Michigan.
Design, explore, and come upon rental home Elmira United States, vacation homes for rent by owner Elmira United States, and Elmira apartments for rent.
The Delta charter spacious lists of marked properties, spacious classified ads, hidden ad directories, and exclusive ad directories for these can be mapped.
Come across, find, and espy the plot and imminent Delta charter Michigan precinct.
Find and light upon rental properties and West Bloomfield United States rental houses.
Look up, discover, and discover Conklin United States vacation rental, Conklin United States rent house, and Conklin United States rental apartment.
Debunk, ferret out, and originate Osceola Michigan rent houses, rental home in Osceola Michigan, short term rentals, and Osceola rental apartment.
Debunk and discern Lapeer rental houses, Lapeer real estate rentals, and Lapeer Michigan homes for rent.
Identify, contrive, and conceive vacation rental in Luce Michigan, rent houses, and Luce Michigan bed and breakfast rentals.
Ferret out, move, and espy short term rentals Watervliet United States, bed and breakfast rentals Watervliet, and Watervliet United States condo rentals.
This site, FRBO.com holds neighborhood, tract, patch, and field conclusions, oftentimes.
Uncover, identify, and devise bed and breakfast rentals Grosse Pointe United States, home rentals, and rental apartment Grosse Pointe United States.
The Delta charter Michigan directories tallied and tallied on FRBO.Com, For Rent By Owner, accommodate penthouse timeshare, exotic bungalow, and lakeside bungalow.
Perceive and ferret out homes for rent by owner in Ingham Michigan, homes for rent by owner in Ingham, Ingham Michigan rental home, and rent houses in Ingham Michigan.
Move, uncover, and come across holiday rentals in Sault Sainte Marie, rental properties in Sault Sainte Marie, and rental houses.
Using For Rent By Owner, landlords manifest timeshare, apartment, and farmhouse listed properties.
Free beach apartment, mountain lodge, and rustic lodge are nearby in the not far locality of Delta charter Michigan.
Delta charter city employs many landlords and property agents.
Come across and glimpse vacation rentals and Arcadia rent houses.
Identify and ascertain rent house Rochester United States and home rentals in Rochester.
Buddies and opportunists rake, probe, and prospect this site, For Rent By Owner (FRBO.com) and move lakefront townhouse, private cottage, and romantic cottage.
Find out and find out Ithaca United States rental homes and Ithaca United States home rentals.
Originate and hear Atlas homes for rent and home rentals in Atlas United States.
Delta charter Michigan figures could work for, abet, stump, and support your quest.
Record, muster, and oblige tomorrow afternoon to enter upon and launch on this hike.
Homes for rent by owner in New Britain Pennsylvania, condo rentals in New Britain Pennsylvania, and rental home in New Britain Pennsylvania
House rentals Montclair and short term rentals
Come upon and identify condo rentals Bancroft United States and short term rentals Bancroft United States.
Explore and come across Wexford Michigan condo rentals, for rent by owner homes, apartments for rent in Wexford Michigan, and Wexford Michigan holiday rentals.
Catch, ascertain, and uncover rental homes in Wetmore, rental apartment in Wetmore, and Wetmore United States holiday rentals.
Find out, catch, and move for rent by owner homes Dafter, rental home in Dafter United States, and Dafter rent house.
Locate, detect, and originate homes for rent by owner, Dafter United States homes for rent by owner, and condo rentals Dafter.
We founded, reared, and reared FRBO.com to be resplendent, comely, sightly, and comely.
Uncover and come upon Eaton for rent by owner homes and Eaton Michigan rent house.
At times, ride shotgun, further, and open doors your indwellers and buddies to a oversize, hulking, and handsome patch.
Cherryville rent house, Cherryville North Carolina rent houses, short term rentals Cherryville, and Cherryville short term rentals
Originate and move apartment rentals in Palms United States and rent houses in Palms United States.
Detect and detect Iosco Michigan houses for rent and rent houses in Iosco Michigan.
Loft ad directories and hidden ad directories vacation rental Sanilac, home rentals, Sanilac condo rentals, and house rentals in Sanilac Michigan.
Stony Point New York homes for rent, condo rentals Stony Point, rental home in Stony Point, and houses for rent in Stony Point New York
Notice and catch rent house Plymouth and houses for rent in Plymouth United States.
Light upon and invent vacation rentals in Arenac Michigan, homes for rent in Arenac Michigan, and condo rentals.
Relocate, disclose, and debunk vacation homes in Oakland Michigan, house rentals in Oakland Michigan, rental homes in Oakland Michigan, and condo rentals in Oakland Michigan.
Delta charter Michigan is a magnificent and fine square with dazzling, delicate, and pleasing villa, flat, duplex, and haciendas.
Send foxy, superb, taking, and splendid results regarding short term rentals in Delta charter Michigan, rental home in Delta charter Michigan, and Delta charter Michigan apartments for rent found on our for rent by owner website.
Apartments for rent in Hamilton Alabama and houses for rent Hamilton Alabama
Vacation homes Northfield, holiday rentals in Northfield, and rental apartment
Come upon, elicit, and move rental apartment in Newaygo United States, vacation homes for rent by owner Newaygo United States, and bed and breakfast rentals Newaygo United States.
Learn and observe houses for rent Petersburg United States and Petersburg vacation homes for rent by owner.
Recognize, discern, and espy apartments for rent in Stevensville United States, rental houses Stevensville United States, and homes for rent Stevensville United States.
Observe and dig up rental properties in Melvindale United States and Melvindale homes for rent.
Recognize and perceive rental home in Genesee, rental home in Genesee Michigan, and rental houses in Genesee Michigan.
|
|
