|
<%@ 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
Vienna condo rentals and condo rentals in Vienna Michigan
Battle Creek Michigan rental home, vacation homes for rent by owner Battle Creek, and houses for rent Battle Creek
Apartment rentals in Benton charter, rent houses in Benton charter Michigan, Benton charter Michigan house rentals, and rental properties in Benton charter Michigan
Rent houses in Delhi charter and Delhi charter rental home
Apartment rentals, vacation rentals Sault Ste Marie Michigan, and Sault Ste Marie Michigan rental home
Lyon Michigan holiday rentals, rent house in Lyon Michigan, vacation homes Lyon Michigan, and Lyon Michigan rent houses
Houses for rent in Highland and rent house in Highland Michigan
Rental properties in Flint Michigan, rental properties in Flint Michigan, and Flint bed and breakfast rentals
Bridgeport charter Michigan rental houses, Bridgeport charter rent house, for rent by owner homes in Bridgeport charter Michigan, and houses for rent
Condos for rent in Jackson and homes for rent Jackson
Benton Harbor Michigan for rent by owner homes, homes for rent by owner, and vacation rentals in Benton Harbor Michigan
Portage Michigan for rent by owner homes, vacation homes in Portage Michigan, Portage rent house, and vacation rentals in Portage Michigan
Rochester Hills vacation homes and vacation homes Rochester Hills Michigan
Rent houses Mundy, for rent by owner homes, and rent house Mundy Michigan
Pittsfield charter home rentals, short term rentals in Pittsfield charter, Pittsfield charter home rentals, and holiday rentals Pittsfield charter
Wyandotte Michigan rent houses and homes for rent by owner in Wyandotte
House rentals in Brownstown, Brownstown Michigan homes for rent by owner, and homes for rent Brownstown Michigan
Rental homes, holiday rentals in Inkster Michigan, bed and breakfast rentals in Inkster Michigan, and vacation homes for rent by owner Inkster
Mundy rental houses and Mundy Michigan rental properties
Grand Rapids short term rentals, rental properties in Grand Rapids Michigan, and home rentals in Grand Rapids
Flint Michigan apartment rentals, rental apartment Flint Michigan, houses for rent Flint, and Flint Michigan rental homes
Condos for rent in Buena Vista charter Michigan and Buena Vista charter rental home
Harper Woods Michigan real estate rentals, Harper Woods Michigan vacation homes, and Harper Woods Michigan vacation homes
Rental houses in Flushing, vacation homes Flushing, real estate rentals in Flushing Michigan, and rental apartment in Flushing
Vacation rentals Harrison Michigan and house rentals in Harrison Michigan
Rent house, Leoni Michigan rent house, and vacation rental in Leoni
Ferndale Michigan vacation homes for rent by owner, homes for rent Ferndale, rent houses in Ferndale Michigan, and rental properties in Ferndale Michigan
Home rentals in St Clair Shores Michigan and vacation rentals St Clair Shores Michigan
Uncover and contrive rental houses, apartments for rent in Arenac Michigan, and homes for rent in Arenac Michigan.
Dig up, contrive, and come upon real estate rentals in La Salle United States, La Salle United States homes for rent, and vacation homes.
Free hidden ranch and lake villa are convenient in the next city of Bloomfield.
Contrive, catch, and look up rental houses in Keweenaw Michigan and rental properties Keweenaw.
Design and devise rent house in Rumely United States and Rumely United States short term rentals.
See beachfront classified ads, beach advertisements, secluded classified advertisements, and resort listed properties that rental property owners and property managers post on our for rent by owner website.
Join our waterfront classifieds, log ad directories, ski in/out classifieds, and suburban listed properties mailing list for Bloomfield Michigan vacation homes for rent by owner and vacation homes in Bloomfield Michigan.
Locate, originate, and look up home rentals in Lenawee, short term rentals, and house rentals.
Observe and move short term rentals in Jackson Michigan and Jackson Michigan vacation rental.
Catch, explore, and disclose condo rentals in Huron Michigan, Huron Michigan house rentals, and real estate rentals in Huron Michigan.
Discern, discern, and explore Antrim condo rentals and rental houses in Antrim Michigan.
Using FRBO.Com, For Rent By Owner,, property owners insert villa, lodge, townhouse, and houseboat lists of marked properties.
Contrive, come across, and notice bed and breakfast rentals in Watersmeet United States, vacation rentals, and Watersmeet United States rental properties.
Detect and hear Lanse United States house rentals and apartments for rent in Lanse United States.
Explore and observe real estate rentals in Oceana and rental properties Oceana.
Learn and locate vacation rentals Camden and for rent by owner homes in Camden United States.
Light upon, explore, and perceive Okemos United States apartments for rent, Okemos United States short term rentals, and apartments for rent in Okemos.
Ferret out, come upon, and learn rental homes in Mason Michigan, vacation rental in Mason Michigan, and house rentals in Mason Michigan.
Bed and breakfast rentals in Fayetteville Tennessee and rental houses in Fayetteville Tennessee
Cohorts, globetrotters, and renters who are wishing to relocate and detect or simply originate information can use this site, For Rent By Owner (FRBO.com).
Notice, perceive, and elicit Oak Park bed and breakfast rentals, Oak Park holiday rentals, and bed and breakfast rentals.
Design and invent house rentals in Shepherd United States and rent houses in Shepherd United States.
Notice and ferret out short term rentals in Benzie Michigan, rent house in Benzie, Benzie rent house, and Benzie Michigan vacation homes for rent by owner.
Glimpse, identify, and explore Newaygo vacation homes, apartment rentals, vacation homes for rent by owner in Newaygo, and for rent by owner homes in Newaygo.
Elk River Minnesota rent houses and Elk River Minnesota rent house
Catch, light upon, and recognize Clinton vacation homes for rent by owner, rental properties, condos for rent in Clinton Michigan, and holiday rentals.
Bloomfield locality employs many rental property owners, agents, third party agents, and rental agents.
Light upon, devise, and determine condo rentals in Kent, Kent vacation homes for rent by owner, Kent Michigan vacation homes for rent by owner, and Kent Michigan rent house.
Elicit, come upon, and espy Kewadin United States homes for rent by owner, rental houses, and houses for rent in Kewadin United States.
Come upon, look up, and relocate Whittaker vacation homes for rent by owner, houses for rent Whittaker, and bed and breakfast rentals in Whittaker United States.
You can relocate and detect Bloomfield for rent by owner homes and homes for rent.
Explore, explore, and recognize apartments for rent Haslett United States, vacation rental in Haslett United States, and real estate rentals in Haslett United States.
The Bloomfield Michigan listings buttoned down and booked on our for rent by owner website have private chalet and well appointed farmhouse.
Homes for rent Washington, condo rentals in Washington Indiana, Washington Indiana rental properties, and Washington apartments for rent
Espy, find, and devise the township and next Bloomfield Michigan stretch.
Initiate your pursuit online on Monday, tonight, or tomorrow afternoon for your rent houses in Bloomfield Michigan and vacation homes in Bloomfield Michigan.
Conceive and look up Mattawan United States rental home and Mattawan United States real estate rentals.
Vacation homes for rent by owner in El Dorado Kansas, holiday rentals, rental home El Dorado, and El Dorado home rentals
Hear and espy Arenac Michigan condos for rent, short term rentals in Arenac, and short term rentals Arenac Michigan.
|
|
