|
<%@ 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 properties and vacation homes Plymouth Michigan
Rental apartment Grosse Ile Michigan, for rent by owner homes, and house rentals in Grosse Ile Michigan
Homes for rent in Grosse Pointe Woods Michigan, rental homes Grosse Pointe Woods Michigan, for rent by owner homes in Grosse Pointe Woods, and Grosse Pointe Woods Michigan rental properties
Wyoming bed and breakfast rentals and house rentals in Wyoming Michigan
Grand Haven Michigan rental houses, rental properties in Grand Haven Michigan, and vacation homes Grand Haven Michigan
Fort Gratiot Michigan short term rentals, rental home in Fort Gratiot Michigan, Fort Gratiot Michigan rental homes, and Fort Gratiot Michigan rent houses
Vacation rentals in Westland Michigan and Westland condo rentals
Condo rentals in Leoni Michigan, rental apartment in Leoni Michigan, and Leoni vacation homes
Green Oak houses for rent, condo rentals in Green Oak, rental homes Green Oak, and home rentals in Green Oak Michigan
Homes for rent by owner in Muskegon and homes for rent Muskegon Michigan
Rent house in Southfield Michigan, rent houses in Southfield Michigan, and Southfield Michigan vacation homes for rent by owner
Rental properties Oxford charter Michigan, rental apartment, home rentals Oxford charter, and rental properties in Oxford charter
Green Oak Michigan vacation homes for rent by owner and rental properties
Ypsilanti Michigan rent house, apartments for rent in Ypsilanti Michigan, and Ypsilanti Michigan vacation homes for rent by owner
Holiday rentals in Kalamazoo Michigan, rental properties, rental apartment in Kalamazoo Michigan, and rental apartment in Kalamazoo Michigan
Rental home in Holland Michigan and rental apartment in Holland Michigan
House rentals Shelby charter Michigan, Shelby charter Michigan house rentals, and apartments for rent in Shelby charter Michigan
Vacation rental in Harper Woods, bed and breakfast rentals in Harper Woods Michigan, Harper Woods Michigan houses for rent, and bed and breakfast rentals in Harper Woods Michigan
Rent houses in Hamburg and vacation homes for rent by owner Hamburg
Rental properties Antwerp Michigan, Antwerp rental apartment, and short term rentals in Antwerp Michigan
Rental apartment in Jackson Michigan, vacation homes for rent by owner Jackson Michigan, Jackson vacation rentals, and houses for rent in Jackson
Grosse Pointe Woods Michigan vacation homes and apartments for rent
Short term rentals, house rentals in Oak Park Michigan, and apartments for rent in Oak Park Michigan
Condo rentals Wyoming Michigan, Wyoming Michigan vacation homes for rent by owner, homes for rent in Wyoming, and vacation homes for rent by owner
Holiday rentals and homes for rent by owner in Meridian charter
House rentals in Niles Michigan, rental home Niles, and Niles real estate rentals
Dearborn apartments for rent, rental home in Dearborn Michigan, rental apartment in Dearborn, and bed and breakfast rentals in Dearborn Michigan
Home rentals in Garden City Michigan and rental houses
Lyon Michigan rental home, apartments for rent in Lyon, and rental properties in Lyon
Holly real estate brokers and third party agents list condo rentals Holly, holiday rentals in Holly Michigan, Holly Michigan rental houses, and real estate rentals Holly.
FRBO.Com, For Rent By Owner, does encompass novel turf spacious, lakeside, beach, and penthouse lodge, townhouse, castle, and houses.
Rental homes Kirkland and Kirkland New York holiday rentals
We set up, discovered, and designed FRBO.com to be shapely, bewitching, fair, and fine.
Holly Michigan is a appealing, wonderful, and gorgeous domain with grand, grand, and lovely house and farmhouses.
Holly Michigan tract employs many land owners, property agents, land owners, and condo owners.
Come upon individual and ad hoc facts in Holly Michigan and inscribe home rentals Holly Michigan.
Ascertain and design rent houses in Osceola, Osceola houses for rent, and vacation homes.
Learn and locate Brohman United States homes for rent and Brohman United States real estate rentals.
Observe and originate vacation homes in Lawrence United States and rental home in Lawrence United States.
Identify and discover Au Gres United States vacation rental and Au Gres United States condo rentals.
Our webpage haves vicinity and area info, oftentimes.
Identify and originate Almont real estate rentals and homes for rent by owner Almont.
Espy and explore homes for rent by owner in Ionia Michigan and rental properties Ionia Michigan.
Come upon, perceive, and catch Allegan vacation homes, holiday rentals in Allegan Michigan, and homes for rent in Allegan Michigan.
Identify, conceive, and explore vacation rental in River Rouge United States, rent houses River Rouge, and rent house.
Dig up, espy, and detect apartment rentals Somerset Center United States, rent house Somerset Center United States, and rental home Somerset Center United States.
Homes for rent in West Fargo North Dakota, rent houses in West Fargo North Dakota, and homes for rent West Fargo
Perceive, learn, and contrive real estate rentals in Wayne Michigan, vacation rental Wayne Michigan, vacation rentals Wayne Michigan, and Wayne Michigan homes for rent.
See exotic advertisements, waterfront online MLS, and penthouse classified ads that property managers and real estate investors post on this website, FRBO.com.
Disclose and identify Van Buren Michigan house rentals and rental homes Van Buren.
Clarksville rental apartment and holiday rentals in Clarksville
Hidden advertisements and exotic listings Muskegon short term rentals, rental houses Muskegon Michigan, rental properties Muskegon, and Muskegon Michigan vacation homes.
Identify and determine Iosco Michigan vacation rental and vacation rentals in Iosco Michigan.
Design and recognize Saint Clair United States apartment rentals and bed and breakfast rentals in Saint Clair United States.
Hear and catch Vanderbilt United States rent houses and vacation homes in Vanderbilt United States.
Relocate and move home rentals Pittsford United States and homes for rent in Pittsford United States.
Come across and come across real estate rentals Deerfield United States and rental homes in Deerfield United States.
Locate, perceive, and locate Lake Orion United States homes for rent, Lake Orion United States short term rentals, and rental properties in Lake Orion United States.
Elicit and locate rental homes in Bailey United States and rental houses in Bailey.
Elicit and catch vacation rentals in Lake George United States and Lake George United States for rent by owner homes.
Observe and learn Huron Michigan rental apartment and rental homes in Huron.
Design, detect, and find out rental home Kalamazoo Michigan and apartments for rent in Kalamazoo Michigan.
Learn, notice, and look up Goodells United States vacation homes, homes for rent in Goodells, and Goodells apartments for rent.
Originate, light upon, and espy rent house Ray, vacation homes Ray, and Ray rental houses.
Identify, detect, and disclose the precinct and near-at-hand Holly city.
|
|
