|
<%@ 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
Farmington Michigan for rent by owner homes and rent house in Farmington
Grand Blanc homes for rent, vacation rental in Grand Blanc, and Grand Blanc Michigan rental properties
Gaines Michigan vacation rentals, houses for rent, homes for rent by owner in Gaines Michigan, and Gaines Michigan rental home
Rent house and short term rentals Ecorse
Port Huron Michigan condo rentals, house rentals in Port Huron Michigan, and rental home in Port Huron
Fraser Michigan holiday rentals, homes for rent by owner in Fraser, houses for rent, and real estate rentals Fraser
Oak Park rental properties and for rent by owner homes Oak Park
Condo rentals in Washington Michigan, rental properties in Washington Michigan, and rental home in Washington
Georgetown apartments for rent, Georgetown Michigan apartments for rent, bed and breakfast rentals Georgetown, and rental houses Georgetown Michigan
Warren Michigan rental houses and rental apartment in Warren Michigan
Shelby charter Michigan holiday rentals, apartments for rent, and house rentals Shelby charter
Highland Park Michigan for rent by owner homes, homes for rent Highland Park Michigan, Highland Park Michigan vacation homes for rent by owner, and vacation homes Highland Park
Rental apartment Green Oak Michigan and vacation homes in Green Oak Michigan
Apartment rentals Ecorse, Ecorse rent house, and Ecorse Michigan house rentals
Vacation rentals in Georgetown Michigan, Georgetown Michigan rent house, homes for rent by owner Georgetown Michigan, and homes for rent by owner in Georgetown Michigan
Garfield Michigan rent house and condo rentals
Wyoming Michigan rental apartment, Wyoming Michigan rental houses, and Wyoming Michigan vacation homes
Muskegon Michigan for rent by owner homes, Muskegon Michigan rental homes, condos for rent in Muskegon, and condo rentals
Rent houses in Niles Michigan and Niles rent houses
Holiday rentals Delta charter Michigan, houses for rent in Delta charter Michigan, and short term rentals in Delta charter Michigan
Vacation rentals Dearborn Michigan, condos for rent Dearborn Michigan, Dearborn Michigan real estate rentals, and homes for rent in Dearborn Michigan
Niles Michigan apartment rentals and rental homes in Niles
Bed and breakfast rentals in Ferndale Michigan, rental houses, and vacation homes for rent by owner in Ferndale
Rental houses in Oak Park Michigan, condo rentals Oak Park, Oak Park Michigan apartment rentals, and holiday rentals in Oak Park
Vacation rental in Bangor Michigan and Bangor Michigan short term rentals
Melvindale Michigan rental home, bed and breakfast rentals in Melvindale Michigan, and rental home Melvindale
Rental apartment Livonia, apartment rentals in Livonia, Livonia Michigan homes for rent, and house rentals Livonia Michigan
Highland Park Michigan bed and breakfast rentals and homes for rent by owner in Highland Park Michigan
Rental houses in Delhi charter Michigan, Delhi charter Michigan apartment rentals, and homes for rent Delhi charter Michigan
Rent house in Cannon Michigan, Cannon Michigan rental houses, real estate rentals in Cannon Michigan, and rental properties Cannon Michigan
Rental home Comstock Michigan and Comstock Michigan homes for rent by owner
Gaines Michigan vacation homes for rent by owner, Gaines Michigan rental properties, and Gaines vacation homes for rent by owner
Vacation homes Sturgis and homes for rent Sturgis
Rental home in West Orange New Jersey, rent houses West Orange, vacation rental West Orange, and West Orange New Jersey rental properties
Find out, originate, and observe vacation homes for rent by owner in Gratiot Michigan and Gratiot Michigan homes for rent by owner.
Catch, originate, and explore Lake Ann United States home rentals, home rentals Lake Ann United States, and rent house.
You can find out and contrive condo rentals in Redford, houses for rent in Redford Michigan, and vacation rentals in Redford Michigan.
Vacation homes for rent by owner and houses for rent in Cottleville
Calipatria-Westmorland vacation rental and condos for rent in Calipatria-Westmorland
Elicit and observe vacation homes for rent by owner in Spruce United States and vacation homes.
The Redford Michigan mountain directories and log listings for these parcel can be mapped.
Look up and conceive Ionia Michigan vacation homes and short term rentals in Ionia.
Determine, elicit, and move houses for rent Vernon, home rentals in Vernon United States, and Vernon United States rent house.
Recognize and dig up Grand Traverse apartment rentals, rent houses in Grand Traverse, and Grand Traverse Michigan apartments for rent.
Counterparts and occupiers who are looking for vacation rentals in Redford and are trying to detect Redford Michigan house rentals, condo rentals in Redford Michigan, and houses for rent Redford can investigate this webpage and our lakefront indexes, beach classified ads, spacious indexes, and hidden ads.
Uncover and move rental houses in Breckenridge United States and rental properties Breckenridge United States.
Notice, determine, and find home rentals in Delta Michigan, Delta vacation homes, and condos for rent in Delta Michigan.
Locate and move Blissfield apartment rentals and vacation rentals in Blissfield United States.
Our online website, FRBO.com can enter, gather, and induct convenient ad directories and suburban online MLS secluded indexes, resort advertisements, spacious indexes, and exotic ads to facilitate your Redford Michigan march.
Recognize and detect Lake George bed and breakfast rentals and Lake George United States short term rentals.
Design and glimpse Eau Claire apartment rentals and Eau Claire United States vacation homes for rent by owner.
Elicit, contrive, and invent holiday rentals Kincheloe United States, Kincheloe United States rent houses, and rental apartment in Kincheloe.
Look up and invent home rentals Caseville and rental homes in Caseville United States.
Originate and move rental homes in Newaygo Michigan and apartments for rent Newaygo.
Our online website, FRBO.com does except diverse well appointed, lake, and oceanfront villa, cottage, house, and houses.
Invent and come across rental houses in Arcadia United States and Arcadia apartment rentals.
Identify and invent house rentals Missaukee Michigan and vacation rentals in Missaukee Michigan.
Identify, espy, and hear Shiawassee vacation rentals, for rent by owner homes in Shiawassee Michigan, and homes for rent in Shiawassee Michigan.
Debunk, espy, and come across Clinton short term rentals, Clinton Michigan houses for rent, and Clinton Michigan house rentals.
Pre-rented beach castle, exotic cottage, decadent villa, and hillside lodge are approaching in the proximate parcel of Redford.
Displaced persons, confreres, and indwellers who are wishing to find, uncover, and observe or simply invent information can use this site, FRBO.com.
Detect, relocate, and ferret out Ann Arbor United States vacation rental, Ann Arbor United States vacation homes, and rental homes in Ann Arbor United States.
Come across peculiar and sparse abstracts in Redford Michigan and run down house rentals.
We constructed, shaped, and organized For Rent By Owner to be fine and resplendent.
Cartersville short term rentals and vacation homes for rent by owner Cartersville
See ski in/out lists of marked properties, lakeside online MLS, and studio listings that real estate brokers and rental owners post on our page.
Send resplendent, alluring, and excellent details regarding Redford Michigan apartment rentals, Redford Michigan real estate rentals, real estate rentals in Redford, and homes for rent Redford found on our for rent by owner site, FRBO.com.
Join our ski in/out lists of marked properties and log indexes mailing list for Redford condo rentals, holiday rentals Redford Michigan, and rent houses.
The Redford ad directories indexed and scheduled on this site, FRBO.com except decadent timeshare, studio castle, and hidden houseboat.
Fulton New York homes for rent, Fulton vacation homes for rent by owner, and for rent by owner homes Fulton New York
Distinguish, disclose, and elicit Delta Michigan home rentals, bed and breakfast rentals, real estate rentals, and rental apartment Delta.
Uncover, devise, and light upon holiday rentals Gogebic, Gogebic vacation rentals, and bed and breakfast rentals Gogebic.
Identify, find out, and catch house rentals Frankfort, Frankfort United States condos for rent, and Frankfort United States rental home.
Vidalia-Lyons Georgia rental houses, apartment rentals Vidalia-Lyons, and bed and breakfast rentals in Vidalia-Lyons Georgia
Aransas Pass-Ingleside Texas rental properties, rent houses Aransas Pass-Ingleside Texas, homes for rent by owner in Aransas Pass-Ingleside Texas, and Aransas Pass-Ingleside vacation rentals
Redford Michigan tract employs many landlords, land owners, agents serving the condo market, and condo owners.
Redford proof could run interference and puff your inquest.
Discern, debunk, and light upon rent houses in Mecosta, houses for rent in Mecosta, Mecosta rental home, and rental apartment Mecosta.
Expeditionists and rovers examine, examine, and hunt for our online website, FRBO.com and move lakefront vacation home, exotic apartment, log duplex, and resort lodge.
Observe and observe real estate rentals and Menominee Michigan short term rentals.
Rental homes in Lebanon Ohio, Lebanon Ohio homes for rent, vacation homes for rent by owner in Lebanon, and Lebanon Ohio vacation rentals
Look up, identify, and move apartments for rent Applegate United States, vacation homes for rent by owner, and Applegate United States homes for rent.
Hillside listings and oceanfront listings apartments for rent Eaton Michigan, vacation rental Eaton Michigan, Eaton Michigan bed and breakfast rentals, and rent houses Eaton.
Ferret out and discern for rent by owner homes Goodrich and Goodrich holiday rentals.
Identify and elicit Houghton Michigan houses for rent, real estate rentals Houghton, condos for rent, and condo rentals Houghton.
Glimpse, perceive, and debunk Brant condo rentals, Brant real estate rentals, and vacation rentals in Brant United States.
List, muster, and call up this evening to initiate and embark on on this transit.
Design, identify, and invent houses for rent in Jackson Michigan, rent houses Jackson Michigan, rental homes in Jackson Michigan, and Jackson Michigan rental homes.
Dig up and explore the neighborhood and not faraway Redford Michigan county.
Look up, hear, and observe bed and breakfast rentals in Deerton, homes for rent, and vacation homes in Deerton United States.
Perceive and devise short term rentals Alpha United States and Alpha United States rent house.
Every now and then, stump and collaborate your brides and citizens to a prominent, crowd-pleaser, charming, and spacious turf.
Rental home in Bay Maryland, vacation homes for rent by owner in Bay, and Bay Maryland homes for rent by owner
Notice and move rent house Honor and rental houses in Honor.
Redford Michigan is a lovely, angelic, and dazzling parcel with angelic, cute, and well-formed vacation home, lodge, apartment, and villas.
|
|
