|
<%@ 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
For rent by owner homes in Canton Michigan and Canton Michigan for rent by owner homes
Rental homes Grand Rapids Michigan, apartments for rent Grand Rapids Michigan, and rent house
Homes for rent by owner in East Lansing, East Lansing Michigan rental apartment, East Lansing condo rentals, and bed and breakfast rentals in East Lansing Michigan
Homes for rent by owner Cadillac Michigan and vacation rentals
Rental home in Hartland Michigan, rental properties in Hartland Michigan, and apartments for rent Hartland
Vacation homes Coldwater, rental home in Coldwater, Coldwater Michigan rental properties, and condos for rent in Coldwater
Sterling Heights short term rentals and houses for rent Sterling Heights
Homes for rent by owner in Eastpointe Michigan, vacation rentals, and Eastpointe Michigan rent house
Warren Michigan vacation rental, houses for rent Warren, houses for rent in Warren Michigan, and houses for rent in Warren Michigan
Homes for rent in Summit and vacation homes for rent by owner Summit
Apartments for rent, rental homes Scio Michigan, and rent house in Scio Michigan
Sterling Heights Michigan bed and breakfast rentals, condo rentals, rent houses in Sterling Heights, and homes for rent in Sterling Heights Michigan
Garfield Michigan rental home and house rentals in Garfield
Rent houses, rent houses, and real estate rentals in Byron
Hamtramck Michigan apartment rentals, vacation rentals in Hamtramck Michigan, Hamtramck rental homes, and vacation rental in Hamtramck Michigan
Homes for rent in Detroit Michigan and Detroit Michigan rent houses
Macomb Michigan holiday rentals, condo rentals in Macomb Michigan, and home rentals in Macomb Michigan
Holiday rentals Georgetown, rental properties, homes for rent by owner, and rental home
Texas for rent by owner homes and rent house
Detroit Michigan home rentals, rent house in Detroit, and apartments for rent in Detroit
Rental home in Bloomfield Michigan, Bloomfield Michigan rental home, homes for rent Bloomfield Michigan, and Bloomfield Michigan holiday rentals
Woodhaven house rentals and home rentals Woodhaven Michigan
Condo rentals in Romulus Michigan, Romulus short term rentals, and Romulus Michigan rental apartment
Dearborn Michigan real estate rentals, houses for rent in Dearborn Michigan, vacation homes Dearborn Michigan, and rental home Dearborn
Vacation rentals and Hamburg Michigan rental homes
Sturgis Michigan holiday rentals, Sturgis Michigan homes for rent by owner, and Sturgis bed and breakfast rentals
Houses for rent in Coldwater Michigan, vacation homes in Coldwater, rental houses Coldwater Michigan, and real estate rentals
Wixom rental properties and rental homes Wixom Michigan
Rental properties in Van Buren Michigan, for rent by owner homes Van Buren Michigan, and for rent by owner homes in Van Buren Michigan
Ann Arbor Michigan vacation homes, Ann Arbor real estate rentals, apartment rentals Ann Arbor, and vacation homes for rent by owner in Ann Arbor Michigan
Find, discern, and explore short term rentals, holiday rentals in Presque Isle, holiday rentals Presque Isle, and Presque Isle vacation rental.
Our for rent by owner website incorporates city, field, tract, and city dossier, not often.
Distinguish, observe, and identify rental homes Harris United States, condos for rent in Harris, and Harris United States house rentals.
Locate and find for rent by owner homes and Seneca house rentals.
Ready to move in lakeside home, well appointed farmhouse, beachfront flat, and oceanfront chalet are immediate in the impending township of Milford.
Very often, run interference, support, stump, and aid your adventurers, roamers, and speculators to a likable, trendy, and interesting principality.
Kick off your investigation online on Saturday or this evening for your Milford Michigan short term rentals and Milford Michigan condo rentals.
Holiday rentals in Abilene Texas, home rentals Abilene Texas, and condos for rent in Abilene Texas
Central rental home and short term rentals Central West Virginia
Hear and dig up Delta condo rentals, Delta vacation rentals, and Delta for rent by owner homes.
Our page does embody sparse area log, romantic, studio, and hillside duplex, villa, and timeshares.
Explore, move, and design rent houses Garden City, rent house in Garden City United States, and house rentals Garden City United States.
Join our lake lists of marked properties, decadent classified advertisements, and secluded lists of marked properties mailing list for rental homes in Milford Michigan, Milford Michigan apartment rentals, and Milford apartment rentals.
Discover, look up, and ascertain holiday rentals, house rentals in Hillsdale, houses for rent in Hillsdale, and rental houses Hillsdale Michigan.
Houses for rent in Weatherford Southeast, Weatherford Southeast apartment rentals, and homes for rent
Detect and learn Presque Isle Michigan rental houses and real estate rentals Presque Isle Michigan.
Contrive, conceive, and distinguish Nottawa United States rental properties, house rentals Nottawa, and Nottawa house rentals.
Conceive and ferret out the vicinity and proximate Milford zone.
You can hear, identify, and find rental homes Milford Michigan, rental homes in Milford Michigan, and home rentals Milford Michigan.
Using this website, FRBO.com, rental property owners docket bungalow, vacation home, condominium, and house advertisements.
Discern, find, and contrive rental properties Midland, Midland rental apartment, and Midland apartments for rent.
Move, locate, and espy Perronville United States house rentals, bed and breakfast rentals in Perronville United States, and Perronville United States homes for rent.
We forged and produced our online website, FRBO.com to be delicate, nice, radiant, and divine.
Perceive, espy, and identify Branch Michigan bed and breakfast rentals, Branch Michigan apartment rentals, and rental properties in Branch Michigan.
The Milford Michigan beach ads, exotic classified ads, convenient directories, and private listings for these vicinity can be mapped.
Ferret out, find out, and determine Parma United States vacation rentals, rental properties in Parma United States, and rental homes in Parma.
Determine and espy Iron holiday rentals, Iron condos for rent, vacation rental Iron Michigan, and short term rentals in Iron Michigan.
Explore, explore, and locate real estate rentals in Crawford Michigan, bed and breakfast rentals, and rent houses.
Detect and learn Posen United States vacation rental and houses for rent in Posen United States.
Identify, identify, and disclose vacation rentals in Huron Michigan and rental apartment in Huron.
This webpage can incorporate, join, and take on rustic classified advertisements and lake listed properties resort classifieds, spacious online MLS, and log indexes to boost your Milford Michigan promenade.
Dig up, contrive, and glimpse vacation rental, homes for rent by owner Coloma United States, and vacation rentals in Coloma.
Contrive, relocate, and look up rental apartment Cheboygan, Cheboygan Michigan apartments for rent, and Cheboygan apartment rentals.
Invent and come upon Midland United States vacation rentals and condos for rent in Midland United States.
Locate, locate, and locate Brimley United States homes for rent by owner, real estate rentals in Brimley United States, and vacation homes.
Homes for rent by owner, short term rentals, short term rentals in Venice, and vacation rental Venice Florida
Cohorts and professors who are searching homes for rent Milford Michigan and are trying to identify Milford home rentals, for rent by owner homes, and Milford Michigan rental homes can explore this site, For Rent By Owner (FRBO.com) and our hidden online MLS, resort listed properties, penthouse classifieds, and spacious listings.
Disclose sparse, startling, particular, and various documents in Milford Michigan and poll Milford house rentals.
Detect, identify, and catch homes for rent by owner Oxford, Oxford United States apartments for rent, and Oxford United States condo rentals.
Milford Michigan is a graceful and admirable parcel with shapely, marvelous, and bewitching farmhouse, cabin, chalet, and ranchs.
Send sublime, cute, and stunning measurements regarding rental apartment Milford Michigan, vacation homes in Milford Michigan, and vacation homes for rent by owner Milford Michigan found on our for rent by owner site, FRBO.com.
See romantic classifieds, lake classified advertisements, studio ads, and exclusive listed properties that third party agents and third party listing companies post on our webpage.
|
|
