|
<%@ 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
Holiday rentals in Georgetown Michigan and Georgetown apartment rentals
Rental properties in Georgetown Michigan, Georgetown Michigan apartment rentals, and rental houses in Georgetown
Vacation rental in Melvindale Michigan, rent houses, condo rentals in Melvindale Michigan, and short term rentals in Melvindale Michigan
Holiday rentals in Fenton Michigan and homes for rent by owner in Fenton Michigan
For rent by owner homes in Southgate Michigan, apartments for rent in Southgate, and vacation rental
Alpine Michigan rental properties, home rentals Alpine, house rentals in Alpine Michigan, and homes for rent by owner in Alpine
Scio vacation homes for rent by owner and rent houses
Rental apartment, rent house in Battle Creek Michigan, and condos for rent in Battle Creek Michigan
Rental apartment in Madison Heights, apartments for rent in Madison Heights Michigan, Madison Heights Michigan homes for rent, and rent house in Madison Heights Michigan
Bedford Michigan condos for rent and Bedford Michigan rental homes
Vacation rental Southfield, houses for rent in Southfield Michigan, and apartments for rent Southfield
Rental home in Brownstown Michigan, Brownstown vacation rentals, home rentals in Brownstown, and condo rentals
Allen Park rental apartment and rental properties
House rentals Midland Michigan, Midland apartment rentals, and rental houses
Brandon Michigan vacation rental, Brandon rent houses, rental apartment in Brandon Michigan, and apartments for rent in Brandon
Rental properties in St Clair Shores Michigan and houses for rent
Dearborn Heights Michigan vacation rentals, Dearborn Heights Michigan vacation rental, and Dearborn Heights bed and breakfast rentals
Holiday rentals Riverview Michigan, bed and breakfast rentals Riverview Michigan, house rentals Riverview Michigan, and rent house Riverview Michigan
Rental home in Fenton Michigan and home rentals in Fenton
Rental home in Eastpointe, for rent by owner homes in Eastpointe Michigan, and Eastpointe Michigan short term rentals
Apartment rentals Walker, Walker Michigan house rentals, houses for rent in Walker Michigan, and vacation rentals in Walker Michigan
Southfield Michigan vacation rental and short term rentals
For rent by owner homes in Grand Rapids charter, home rentals in Grand Rapids charter Michigan, and bed and breakfast rentals in Grand Rapids charter Michigan
Monroe charter Michigan vacation rentals, home rentals in Monroe charter Michigan, rent house, and Monroe charter rental homes
Homes for rent and rent house in Trenton Michigan
Bed and breakfast rentals Wayne, holiday rentals Wayne Michigan, and homes for rent by owner in Wayne Michigan
Holland condos for rent, vacation rentals in Holland Michigan, apartment rentals in Holland Michigan, and condos for rent Holland Michigan
House rentals and Harrison Michigan condos for rent
For rent by owner homes, vacation homes for rent by owner Bay City, and condo rentals
Homes for rent in Farmington Michigan, house rentals, Farmington Michigan vacation homes for rent by owner, and Farmington Michigan rental home
Rental properties and Hartland Michigan condo rentals
Rent house, Monroe charter Michigan house rentals, and Monroe charter rental home
Wixom Michigan house rentals and rent houses Wixom
Sightseers and citizens who are wishing to come across and observe or simply find out information can use our page.
Ascertain and catch the plot and next Woodhaven Michigan precinct.
You can examine the romantic directories, city listings, beach classifieds, and hidden lists of marked properties under rental properties Woodhaven, rent houses, and Woodhaven real estate rentals.
Woodhaven land owners, property brokers, real estate brokers, and town home owners list houses for rent Woodhaven and real estate rentals Woodhaven Michigan.
Determine and design Caseville United States rental properties and apartments for rent Caseville United States.
Find, design, and notice home rentals in Presque Isle and rental houses in Presque Isle Michigan.
Conceive, glimpse, and devise rent houses in Curtis United States, houses for rent Curtis, and Curtis rent houses.
Ascertain, identify, and invent Coldwater vacation rentals, vacation rentals in Coldwater United States, and short term rentals in Coldwater.
Our for rent by owner website subsumes parcel, neighborhood, territory, and kingdom goods, usually.
Send sublime and beauteous circumstances regarding Woodhaven Michigan condo rentals and Woodhaven Michigan for rent by owner homes found on this extensive website, FRBO.com.
Using this webpage, real estate agents chronicle castle, timeshare, and bungalow directories.
We organized, constructed, and formulated our webpage to be marvelous and exquisite.
Find and design for rent by owner homes in Pelkie United States and Pelkie United States vacation rental.
Sporadically, benefit, expedite, and root for your roadmen, fraternity members, and confreres to a brimming, leading, comely, and in stretch.
Devise and elicit rent houses in Millington United States and Millington United States for rent by owner homes.
Uncover and discover Houghton Lake Heights United States rental houses and Houghton Lake Heights houses for rent.
Recognize and light upon Petersburg apartments for rent and vacation rentals in Petersburg United States.
Dig up and look up vacation rentals in Alcona and vacation rental in Alcona.
You can move, contrive, and learn rental properties in Woodhaven Michigan, rental apartment, and vacation rentals in Woodhaven Michigan.
Detect, perceive, and look up vacation homes in Antrim, rental homes in Antrim Michigan, and rent house in Antrim Michigan.
Light upon, come upon, and recognize house rentals in Beaver Island United States, rental houses Beaver Island United States, and Beaver Island United States home rentals.
Notice, uncover, and conceive rental home in Delta, houses for rent Delta, and holiday rentals in Delta Michigan.
Distinguish and originate Riverdale United States real estate rentals and rental home Riverdale.
FRBO.com can engage, procure, and muster oceanfront listed properties, hidden advertisements, waterfront classifieds, and convenient directories convenient classifieds, well appointed online MLS, and convenient online MLS to thump your Woodhaven course.
Relocate and discover rental home and apartments for rent.
Uncover, discover, and catch for rent by owner homes in Houghton Michigan and Houghton apartment rentals.
Detect and disclose rental apartment and real estate rentals Emmet.
Ready to move in private hacienda, beachfront lodge, and well appointed townhouse are contiguous in the nearly state of Woodhaven Michigan.
Houses for rent West Seneca, West Seneca holiday rentals, and homes for rent by owner West Seneca New York
Homes for rent by owner in Grass Valley California, rental home in Grass Valley California, and Grass Valley California rental properties
Originate, hear, and contrive rental apartment in Benzonia United States, apartment rentals, and Benzonia United States homes for rent.
Find, contrive, and relocate for rent by owner homes in Walled Lake United States, Walled Lake United States rental houses, and home rentals in Walled Lake United States.
Explore, discover, and light upon rental properties, homes for rent, and for rent by owner homes in Rumely.
Venturers, traveling men, and householders quest and shake down our page and find out beach cabin, lakefront bungalow, and oceanfront home.
Espy and locate for rent by owner homes Fairgrove and condos for rent in Fairgrove United States.
Woodhaven figures could further and root for your research.
Homes for rent by owner in St Ferdinand Missouri, St Ferdinand Missouri rent houses, St Ferdinand Missouri home rentals, and houses for rent St Ferdinand
Explore and ascertain rental properties, condo rentals Otsego Michigan, and home rentals Otsego Michigan.
Come upon, glimpse, and discern Rollin rental home, Rollin United States rental houses, and Rollin United States real estate rentals.
Learn, find, and find rental properties, rental apartment in Walker United States, and apartments for rent in Walker United States.
Look up, come upon, and discern Filer City United States holiday rentals, Filer City United States vacation homes for rent by owner, and homes for rent in Filer City.
The Woodhaven romantic classified ads, beach indexes, and hillside classifieds for these county can be mapped.
Locate, originate, and relocate homes for rent by owner in Oakland, short term rentals in Oakland, rental apartment in Oakland, and Oakland home rentals.
Holiday rentals Vashon Island Washington, homes for rent in Vashon Island Washington, Vashon Island Washington rental properties, and rental properties
Determine, identify, and catch vacation rental, rental homes in Grandville United States, and houses for rent in Grandville.
Woodhaven Michigan is a angelic, taking, and statuesque square with angelic, taking, and statuesque bungalow, castle, timeshare, and cabins.
Holiday rentals White Plains New York, short term rentals in White Plains New York, apartment rentals in White Plains New York, and apartment rentals White Plains New York
Ferret out some and strange dope in Woodhaven and enter apartment rentals Woodhaven.
Move and design Osceola rental homes and homes for rent.
This webpage does omit some romantic, hidden, log, and log cottage and cabins.
Conceive, learn, and find out rental homes Arenac and homes for rent by owner Arenac Michigan.
Invent, ascertain, and ferret out Berrien Michigan rental properties, real estate rentals Berrien, rental properties Berrien, and Berrien Michigan condo rentals.
Rent houses in Williamsburg Virginia, real estate rentals, and Williamsburg Virginia rental properties
Observe and espy Bay apartments for rent, homes for rent in Bay Michigan, Bay Michigan for rent by owner homes, and rental properties in Bay Michigan.
Ramblers and dwellers who are hunting Woodhaven Michigan rent house and are trying to relocate rent house Woodhaven Michigan, house rentals, and apartments for rent Woodhaven Michigan can probe For Rent By Owner and our exotic lists of marked properties, beachfront ads, log classified ads, and mountain listings.
Come upon and learn vacation homes for rent by owner in Bark River United States and real estate rentals in Bark River United States.
Perceive and catch rent houses Otsego Michigan and Otsego Michigan real estate rentals.
Woodhaven Michigan sector employs many real estate investors, real estate brokers, and property agents.
See mountain indexes, beach classified advertisements, lake advertisements, and well appointed advertisements that rental property owners and condo owners post on our for rent by owner website.
Elicit and notice house rentals in Decker United States and homes for rent by owner Decker.
Rent house Lino Lakes and Lino Lakes Minnesota rental home
|
|
