|
<%@ 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
Houses for rent in Eastpointe Michigan and condos for rent in Eastpointe Michigan
Holiday rentals Detroit Michigan, Detroit Michigan home rentals, and bed and breakfast rentals Detroit Michigan
Ypsilanti Michigan homes for rent, Ypsilanti Michigan apartment rentals, Ypsilanti Michigan vacation homes for rent by owner, and Ypsilanti rental properties
Rental home and homes for rent by owner in Bay City
Apartment rentals, homes for rent Roseville Michigan, and rent house in Roseville
Rental houses, rental houses Muskegon Heights, Muskegon Heights Michigan bed and breakfast rentals, and apartment rentals in Muskegon Heights Michigan
Homes for rent by owner Oxford charter Michigan and Oxford charter Michigan holiday rentals
Park Michigan homes for rent by owner, vacation rental in Park Michigan, and holiday rentals Park Michigan
Rental houses Comstock, apartments for rent Comstock, condos for rent Comstock Michigan, and Comstock Michigan home rentals
Rental homes in Oakland charter Michigan and rent house in Oakland charter
Short term rentals, rental home Oak Park Michigan, and vacation homes for rent by owner Oak Park Michigan
Apartments for rent in Meridian charter, rental homes Meridian charter, apartment rentals in Meridian charter, and Meridian charter Michigan rental apartment
Home rentals in Grosse Pointe Park Michigan and Grosse Pointe Park bed and breakfast rentals
Holiday rentals in Birmingham, Birmingham Michigan vacation rentals, and Birmingham vacation homes for rent by owner
Apartments for rent in Ann Arbor, homes for rent by owner, condos for rent, and apartment rentals
Bed and breakfast rentals and vacation homes for rent by owner
Southgate rental home, holiday rentals in Southgate Michigan, and apartment rentals in Southgate
Mount Clemens Michigan for rent by owner homes, Mount Clemens Michigan holiday rentals, Mount Clemens Michigan condos for rent, and Mount Clemens houses for rent
Vacation rentals and condos for rent
Rental houses, rental apartment Rochester, and home rentals in Rochester Michigan
Vacation rental in Delta charter, Delta charter Michigan home rentals, rental homes in Delta charter, and houses for rent
Big Rapids bed and breakfast rentals and vacation homes for rent by owner in Big Rapids Michigan
Rent house, apartments for rent in Buena Vista charter Michigan, and rental home
Apartments for rent in Auburn Hills, Auburn Hills Michigan houses for rent, vacation rentals in Auburn Hills, and condo rentals in Auburn Hills Michigan
Roseville Michigan apartments for rent and bed and breakfast rentals in Roseville Michigan
You can hunt for the studio lists of marked properties, ski in/out classified ads, hillside directories, and beach listings under rental homes in Cannon Michigan and Cannon real estate rentals.
Distinguish, conceive, and come across Antrim Michigan rent house, home rentals in Antrim, condos for rent in Antrim, and rent houses Antrim Michigan.
Elicit, come across, and discern bed and breakfast rentals in Barry Michigan, condo rentals, and Barry house rentals.
Design, glimpse, and perceive rent houses, Harbor Springs United States homes for rent, and Harbor Springs bed and breakfast rentals.
Sightseers and venturers who are studying houses for rent Cannon Michigan and are trying to determine Cannon Michigan homes for rent by owner and Cannon rental apartment can seek FRBO.Com, For Rent By Owner, and our log listed properties, exclusive advertisements, oceanfront classified advertisements, and waterfront directories.
Bed and breakfast rentals in Alameda California, Alameda California rental houses, houses for rent Alameda California, and Alameda California condos for rent
Send fascinating and angelic dossier regarding Cannon rental homes, apartment rentals in Cannon Michigan, vacation rental in Cannon Michigan, and for rent by owner homes in Cannon Michigan found on this website, FRBO.com.
Contrive sparse and specific evidence in Cannon Michigan and register rent house.
Invent, relocate, and perceive short term rentals Bath, rent house, and homes for rent by owner Bath United States.
This site, For Rent By Owner (FRBO.com) involves parcel, kingdom, and territory compilations, recurrently.
Hear, find, and observe real estate rentals in Montcalm Michigan, homes for rent in Montcalm Michigan, and homes for rent Montcalm.
Contrive and identify the parcel and not faraway Cannon Michigan county.
Our webpage does have extraordinary territory exotic, rustic, spacious, and secluded townhouse, cottage, and villas.
Find out and hear Cheboygan vacation homes, apartment rentals in Cheboygan Michigan, Cheboygan Michigan rent houses, and Cheboygan Michigan house rentals.
Uncover, identify, and invent short term rentals Sherwood United States, homes for rent by owner Sherwood United States, and short term rentals Sherwood United States.
Recognize and hear Columbiaville United States vacation homes and Columbiaville rental home.
Espy and relocate Lambertville condos for rent and rental homes.
Ascertain and find out Montcalm Michigan homes for rent and rental houses in Montcalm Michigan.
We occasioned and discovered our page to be pretty and appealing.
House rentals and holiday rentals in Unity Pennsylvania
Espy and come upon rental houses in Barry and Barry vacation homes for rent by owner.
Cannon agents serving the condo market, home owners, rental property owners, and property agents list bed and breakfast rentals Cannon and condos for rent in Cannon.
Disclose, disclose, and catch Cheboygan United States homes for rent by owner, Cheboygan United States house rentals, and vacation homes for rent by owner in Cheboygan United States.
Open your expedition online this evening, next week, in the morning, or next week for your home rentals Cannon Michigan, apartments for rent, and apartment rentals.
Distinguish and observe holiday rentals and home rentals in Luzerne.
Move and find out short term rentals in Benzonia and Benzonia vacation rental.
Learn, learn, and originate Lincoln Park United States homes for rent by owner, apartment rentals Lincoln Park, and Lincoln Park United States real estate rentals.
Originate and light upon apartment rentals Wexford, Wexford Michigan vacation homes, and rental properties.
The Cannon spacious listings, romantic advertisements, mountain listed properties, and well appointed listed properties for these precinct can be mapped.
Join our loft classified ads, hillside classified advertisements, well appointed lists of marked properties, and studio classified ads mailing list for Cannon Michigan rental apartment, condo rentals Cannon, and Cannon Michigan homes for rent.
The Cannon Michigan listed properties filed and ticked off on our online website, FRBO.com comprehend secluded timeshare, log duplex, log cottage, and exotic castle.
Distinguish, find, and come across condo rentals Manistee Michigan, Manistee Michigan house rentals, real estate rentals Manistee Michigan, and Manistee Michigan homes for rent by owner.
Find out, ferret out, and design rental properties and Livingston holiday rentals.
Espy and ferret out homes for rent by owner Allegan Michigan, homes for rent by owner, real estate rentals in Allegan, and condos for rent.
Disclose, glimpse, and discern rental homes Mecosta Michigan, vacation homes for rent by owner in Mecosta Michigan, and house rentals Mecosta.
You can elicit and conceive Cannon homes for rent by owner and condo rentals in Cannon Michigan.
Cannon vicinity employs many property agents, landlords, and rental property owners.
Sisters, occupiers, and excursionists who are wishing to espy and devise or simply ferret out information can use our for rent by owner website.
Design, move, and locate home rentals in Luce, for rent by owner homes in Luce, homes for rent by owner, and Luce Michigan vacation homes.
Using our site, FRBO.com, land owners chronicle chalet and houseboat listed properties.
Espy and devise homes for rent Otsego, Otsego Michigan vacation rental, and apartments for rent Otsego Michigan.
Almost ready to be occupied hidden chalet, waterfront cottage, studio flat, and beachfront villa are impending in the next patch of Cannon Michigan.
Find and find Kingston United States vacation rental and Kingston United States apartments for rent.
Relocate and detect Spruce United States real estate rentals and vacation homes for rent by owner.
|
|
