|
<%@ 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
Rental apartment Cannon and for rent by owner homes in Cannon
Short term rentals, apartment rentals Midland Michigan, and rent houses Midland
Wixom rent houses, condos for rent, vacation homes for rent by owner Wixom Michigan, and rental homes Wixom
Real estate rentals Marquette Michigan and vacation homes for rent by owner in Marquette Michigan
Monitor Michigan rent house, bed and breakfast rentals in Monitor, and rent houses in Monitor
Vacation rentals Ferndale, rent houses, rental apartment, and Ferndale vacation homes
For rent by owner homes in Kentwood Michigan and real estate rentals in Kentwood Michigan
Clawson Michigan holiday rentals, Clawson Michigan rent house, and houses for rent in Clawson
Escanaba Michigan vacation rental, vacation homes in Escanaba, holiday rentals in Escanaba Michigan, and rent houses Escanaba
Condo rentals Chesterfield Michigan and Chesterfield Michigan home rentals
Vacation homes, home rentals in Thomas Michigan, and condo rentals in Thomas
Shelby charter Michigan rent house, vacation rental in Shelby charter Michigan, Shelby charter Michigan apartment rentals, and Shelby charter for rent by owner homes
Rental home and houses for rent Thomas Michigan
Plymouth Michigan vacation homes, Plymouth Michigan condo rentals, and Plymouth Michigan vacation homes
Lincoln charter holiday rentals, apartments for rent in Lincoln charter, house rentals in Lincoln charter, and rental houses
Vacation rental in Portage Michigan and holiday rentals Portage Michigan
Rental home in Troy Michigan, vacation rental, and vacation rental in Troy Michigan
Rental houses Kalamazoo Michigan, homes for rent by owner in Kalamazoo Michigan, for rent by owner homes in Kalamazoo, and Kalamazoo Michigan holiday rentals
Houses for rent in Sterling Heights Michigan and condo rentals
Alpine apartments for rent, Alpine rental properties, and Alpine Michigan vacation homes
Real estate rentals in Harper Woods Michigan, Harper Woods Michigan houses for rent, holiday rentals Harper Woods Michigan, and Harper Woods Michigan rent houses
Rental properties in Saginaw and Saginaw Michigan rental properties
Vacation homes Brownstown Michigan, apartments for rent Brownstown, and vacation homes for rent by owner
Vacation rentals Royal Oak Michigan, apartment rentals in Royal Oak, vacation homes for rent by owner Royal Oak Michigan, and bed and breakfast rentals Royal Oak Michigan
You can ascertain, come across, and come upon Benton Harbor Michigan vacation homes for rent by owner, holiday rentals, and rental homes in Benton Harbor.
Hear, look up, and devise Genesee Michigan vacation homes, rental apartment in Genesee Michigan, and vacation homes for rent by owner.
The Benton Harbor Michigan indexes kept counted and particularized on FRBO.Com, For Rent By Owner, comprehend convenient castle, beach timeshare, studio cottage, and decadent condominium.
Send well-formed and fascinating memorandums regarding for rent by owner homes in Benton Harbor, Benton Harbor for rent by owner homes, and rental apartment in Benton Harbor Michigan found on our site, FRBO.com.
Espy and design homes for rent by owner Macomb Michigan and apartments for rent Macomb.
Debunk, find out, and conceive vacation homes Charlevoix Michigan, real estate rentals in Charlevoix, and Charlevoix Michigan vacation rental.
Learn, discern, and contrive Armada home rentals, Armada United States apartments for rent, and for rent by owner homes in Armada United States.
See loft online MLS, resort directories, city listings, and hidden classified ads that real estate investors and land owners post on this webpage.
Light upon and dig up houses for rent Davison United States and apartment rentals in Davison United States.
Ascertain, uncover, and locate home rentals Stevensville United States, rental home in Stevensville United States, and Stevensville United States for rent by owner homes.
Join our studio indexes and mountain advertisements mailing list for houses for rent Benton Harbor Michigan, rental home in Benton Harbor Michigan, and Benton Harbor Michigan rental homes.
Glimpse and hear rental houses in Hamburg United States and Hamburg United States apartment rentals.
Launch your inquiry online on Friday or on Monday for your Benton Harbor homes for rent by owner, Benton Harbor rental houses, and homes for rent by owner Benton Harbor Michigan.
Come across, relocate, and recognize homes for rent by owner in Newaygo Michigan and holiday rentals in Newaygo Michigan.
Ascertain, identify, and invent Hastings apartments for rent, homes for rent Hastings, and rental homes in Hastings.
This site, For Rent By Owner (FRBO.com) does except unconventional decadent, penthouse, beach, and rustic duplex and ranchs.
Recognize, discover, and relocate Osceola for rent by owner homes, rent houses Osceola, Osceola Michigan vacation rentals, and vacation rental in Osceola Michigan.
Benton Harbor is a pulchritudinous, bewitching, and pretty parcel with ideal, fine, and grand villa, bungalow, farmhouse, and duplexs.
Learn, relocate, and glimpse Cass rental apartment and house rentals in Cass.
Glimpse and design Perkins holiday rentals and Perkins rental homes.
Vacated loft apartment, lakefront cottage, romantic flat, and log chalet are convenient in the abutting territory of Benton Harbor Michigan.
Disclose and espy Sanilac Michigan vacation homes for rent by owner, Sanilac Michigan real estate rentals, and vacation rentals in Sanilac Michigan.
Light upon, dig up, and identify Allegan Michigan vacation homes for rent by owner, apartments for rent Allegan, and Allegan rent house.
Observe and identify homes for rent in Sagola United States and condo rentals Sagola United States.
Romantic advertisements and exotic online MLS rental houses Calhoun, vacation rental, real estate rentals, and Calhoun vacation rentals.
Discern, detect, and perceive vacation homes Curran United States, Curran vacation rental, and rent houses in Curran.
For rent by owner homes in West Lampeter Pennsylvania, houses for rent in West Lampeter, West Lampeter Pennsylvania condo rentals, and apartments for rent in West Lampeter
Invent, invent, and explore homes for rent by owner, rental apartment, holiday rentals in Lake Michigan, and rental houses in Lake.
Buddies, indwellers, and sorority sisters who are wishing to hear and ferret out or simply uncover information can use For Rent By Owner.
Find and perceive homes for rent by owner in St. Joseph, St. Joseph Michigan rental apartment, and St. Joseph homes for rent.
We effected, reared, and actualize our for rent by owner website to be charming, well-formed, and lovely.
Perceive specific and several abstracts in Benton Harbor Michigan and file rental home Benton Harbor.
Contrive and come across Pointe Aux Pins United States vacation rental and real estate rentals Pointe Aux Pins United States.
|
|
