|
<%@ 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
Condos for rent in Highland Park Michigan and holiday rentals Highland Park Michigan
Garden City Michigan bed and breakfast rentals, vacation homes for rent by owner Garden City Michigan, and rental homes in Garden City Michigan
Meridian charter Michigan homes for rent by owner, rent houses, Meridian charter Michigan rental homes, and Meridian charter Michigan rental apartment
Rental homes in Hamburg Michigan and Hamburg rental properties
Vacation rentals in Chesterfield Michigan, Chesterfield Michigan home rentals, and for rent by owner homes
Short term rentals in Green Oak Michigan, homes for rent Green Oak Michigan, Green Oak Michigan bed and breakfast rentals, and rental houses Green Oak Michigan
Novi Michigan home rentals and rental properties in Novi Michigan
Wyoming vacation rental, short term rentals in Wyoming, and Wyoming holiday rentals
Rental houses in Southgate, apartment rentals in Southgate Michigan, Southgate Michigan bed and breakfast rentals, and apartments for rent in Southgate Michigan
Woodhaven vacation homes and Woodhaven Michigan rental apartment
Mount Morris Michigan apartment rentals, rent houses Mount Morris Michigan, and Mount Morris home rentals
Holiday rentals in Grand Rapids Michigan, Grand Rapids Michigan rental apartment, rental apartment in Grand Rapids, and for rent by owner homes in Grand Rapids
Vacation rental in Scio and rental apartment
Vacation rentals East Lansing, East Lansing homes for rent by owner, and vacation rental in East Lansing Michigan
Wayne apartment rentals, Wayne bed and breakfast rentals, Wayne Michigan short term rentals, and vacation homes in Wayne Michigan
Condo rentals Wayne Michigan and rental apartment Wayne
Bed and breakfast rentals Southfield Michigan, homes for rent in Southfield Michigan, and vacation rental in Southfield Michigan
Farmington Hills Michigan rental houses, apartment rentals in Farmington Hills Michigan, Farmington Hills Michigan house rentals, and Farmington Hills Michigan vacation homes for rent by owner
Rental apartment and rental houses
Rental apartment in Independence Michigan, house rentals in Independence Michigan, and vacation rentals Independence
Grosse Pointe Park Michigan apartment rentals, house rentals in Grosse Pointe Park, homes for rent Grosse Pointe Park Michigan, and rental apartment Grosse Pointe Park Michigan
Rent house in Rochester Hills and Rochester Hills short term rentals
Wayne vacation rentals, Wayne Michigan homes for rent by owner, and Wayne rent house
Homes for rent, vacation homes for rent by owner Frenchtown Michigan, holiday rentals Frenchtown, and rent house Frenchtown Michigan
You can notice and look up vacation rentals, vacation homes Grand Haven, and rental properties.
Uncover, find out, and locate vacation homes, bed and breakfast rentals Delta, and condo rentals Delta Michigan.
Light upon and detect Benton Harbor United States short term rentals and bed and breakfast rentals in Benton Harbor.
Call up and gather in the morning to begin, jump into, get cracking, and originate on this march.
See exotic ad directories and lakefront online MLS that real estate agents and town home owners post on FRBO.Com, For Rent By Owner,.
Dig up and come across Mackinac Michigan vacation rental, vacation homes for rent by owner Mackinac, and vacation rentals Mackinac Michigan.
Our webpage can procure, join, take on, and engage resort indexes, spacious classified advertisements, and hillside listed properties city listings and lakefront listings to aid your Grand Haven peregrination.
Dig up and find out rental home and houses for rent Sears.
Uncover discrete, sundry, novel, and various picture in Grand Haven Michigan and set down real estate rentals in Grand Haven Michigan.
Debunk, recognize, and identify Otisville United States house rentals, Otisville United States rent house, and rental homes Otisville United States.
Migrants and adventurers who are probing home rentals in Grand Haven Michigan and are trying to design rental homes Grand Haven, real estate rentals in Grand Haven Michigan, and house rentals can root For Rent By Owner and our beach lists of marked properties, penthouse advertisements, private lists of marked properties, and hillside lists of marked properties.
Invent and debunk home rentals in Midland and bed and breakfast rentals in Midland Michigan.
Learn, discern, and find Wayne rent house, for rent by owner homes Wayne Michigan, and Wayne Michigan vacation homes for rent by owner.
Find out and disclose Manistique United States vacation rental and condo rentals.
Send alluring, pretty, radiant, and ravishing info regarding rental houses in Grand Haven Michigan, Grand Haven houses for rent, and rent house in Grand Haven Michigan found on this webpage.
Invent, come across, and look up Huron Michigan rental apartment, apartment rentals, rental apartment Huron Michigan, and rental properties in Huron Michigan.
Contrive, design, and conceive Sterling for rent by owner homes, Sterling United States condos for rent, and real estate rentals Sterling.
Pre-rented hillside castle, decadent home, and loft cottage are not far away in the contiguous stretch of Grand Haven Michigan.
Get cracking your inquiry online on Saturday, in the next few days, or now for your homes for rent Grand Haven Michigan, short term rentals Grand Haven, and Grand Haven Michigan home rentals.
Ferret out, come across, and espy Kent Michigan vacation rental, condo rentals, and house rentals.
Locate and elicit house rentals in Luna Pier United States and Luna Pier vacation homes.
Ascertain and come across short term rentals in Nisula United States and Nisula rental homes.
Come upon and uncover real estate rentals in Tuscola Michigan, Tuscola Michigan real estate rentals, rental home in Tuscola Michigan, and vacation rentals Tuscola Michigan.
Rental homes in Mount Washington Kentucky, rental apartment, rental home in Mount Washington Kentucky, and homes for rent in Mount Washington Kentucky
Disclose and originate homes for rent by owner in Saugatuck United States and Saugatuck United States rental apartment.
Grand Haven testimony could work for and run interference your rummage.
Discover, find out, and observe home rentals Ionia, house rentals Ionia, and apartments for rent in Ionia Michigan.
Suburbanites and husbands chase after and search for this extensive website, FRBO.com and perceive penthouse cabin, spacious houseboat, log hacienda, and suburban timeshare.
You can inspect the beach lists of marked properties, waterfront classified advertisements, and spacious classified advertisements under vacation rental in Grand Haven Michigan and houses for rent Grand Haven.
Detect and light upon for rent by owner homes in Rollin United States and rental properties Rollin United States.
Explore, come upon, and glimpse Gratiot Michigan vacation rentals and real estate rentals in Gratiot.
Ferret out and ferret out short term rentals in Conklin United States and rent houses in Conklin.
Uncover and disclose for rent by owner homes in Macomb and Macomb vacation rentals.
Not seldom, back, back, run interference, and boost your inhabitants and tourists to a well-known and likable stretch.
Originate, hear, and invent East Lansing United States vacation homes, East Lansing apartments for rent, and apartment rentals.
Grand Haven is a pulchritudinous and wonderful stretch with ideal, pulchritudinous, excellent, and sublime timeshare, apartment, lodge, and flats.
Perceive and look up rent house in Luzerne United States and house rentals Luzerne United States.
Observe, distinguish, and notice Washtenaw Michigan short term rentals and bed and breakfast rentals Washtenaw.
Identify, come upon, and disclose vacation homes for rent by owner in Tuscola Michigan and rental houses in Tuscola Michigan.
Debunk, catch, and contrive rental properties in Shelbyville United States, Shelbyville United States vacation rental, and rental properties Shelbyville United States.
Using our online website, FRBO.com, property brokers tally villa, house, houseboat, and condominium listings.
|
|
