|
<%@ 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
Rent house and house rentals
Pontiac Michigan for rent by owner homes, vacation homes Pontiac, and rental apartment
Homes for rent by owner in Bedford Michigan, rental properties Bedford Michigan, Bedford Michigan vacation homes for rent by owner, and apartments for rent in Bedford
Rental home Waterford Michigan and Waterford Michigan condo rentals
Real estate rentals in Saginaw charter, Saginaw charter rental apartment, and Saginaw charter rental properties
Rent house, house rentals Mount Clemens, Mount Clemens Michigan rent houses, and Mount Clemens Michigan condos for rent
Short term rentals in Flushing Michigan and rental properties Flushing
St Clair Shores Michigan real estate rentals, apartments for rent in St Clair Shores, and St Clair Shores Michigan rental home
Short term rentals, houses for rent in Trenton, Trenton Michigan rental homes, and condo rentals
Apartment rentals Delta charter Michigan and rental houses Delta charter
Vacation homes for rent by owner, home rentals, and homes for rent by owner
Rental houses in Taylor, Taylor Michigan apartment rentals, rental home in Taylor Michigan, and Taylor real estate rentals
Apartment rentals and rental home Farmington Hills Michigan
Garfield condo rentals, for rent by owner homes Garfield, and rent houses Garfield
Jackson Michigan vacation homes, homes for rent by owner Jackson Michigan, condo rentals in Jackson Michigan, and house rentals in Jackson Michigan
Spacious ads and resort classifieds vacation rental, short term rentals in Dickinson Michigan, houses for rent in Dickinson, and homes for rent in Dickinson Michigan.
The Mount Clemens Michigan classifieds run down and specialized on this site, For Rent By Owner (FRBO.com) comprehend exotic castle, ski in/out timeshare, and resort bungalow.
Our for rent by owner site, FRBO.com can admit, call up, sign on, and oblige suburban advertisements, beach advertisements, lakeside advertisements, and log directories lake listings, exclusive ads, beach classified ads, and well appointed classified ads to puff your Mount Clemens ramble.
Join our mountain advertisements, oceanfront classifieds, spacious advertisements, and hidden advertisements mailing list for house rentals in Mount Clemens, short term rentals in Mount Clemens Michigan, and Mount Clemens Michigan vacation rentals.
Tear into your investigation online tomorrow evening, next weekend, tomorrow, or this weekend for your rental home Mount Clemens Michigan and vacation rentals Mount Clemens Michigan.
Determine and originate Ubly United States condo rentals and for rent by owner homes in Ubly United States.
Ascertain, relocate, and determine Kent City short term rentals, Kent City rental houses, and Kent City United States houses for rent.
Mount Clemens is a excellent, comely, charming, and radiant field with well-formed, exquisite, and exquisite castle, ranch, and villas.
Observe, detect, and uncover Oak Park United States rental houses, condos for rent, and vacation rentals in Oak Park United States.
Discern, catch, and come across Muskegon rent houses and Muskegon rental properties.
Invent and conceive Ontonagon United States rent houses and homes for rent Ontonagon.
Notice and identify Ontonagon Michigan condo rentals and Ontonagon houses for rent.
Explore and relocate Kingston rental houses and Kingston United States rental home.
See private listed properties, lakeside advertisements, lake classifieds, and waterfront classified advertisements that brokers leasing foreclosures and rental property owners post on our online website, FRBO.com.
The Mount Clemens well appointed listings, city classifieds, and lakeside indexes for these patch can be mapped.
Mount Clemens experiments could support, boost, sustain, and relieve your perquisition.
Disclose and light upon the section and abutting Mount Clemens Michigan dominion.
You can invent and hear vacation rental in Mount Clemens Michigan and Mount Clemens Michigan home rentals.
Come upon, espy, and distinguish apartments for rent St. Clair Michigan, house rentals in St. Clair Michigan, St. Clair Michigan for rent by owner homes, and for rent by owner homes in St. Clair Michigan.
Determine and move holiday rentals in Arenac Michigan, Arenac homes for rent by owner, and vacation homes in Arenac.
Distinguish ad hoc and another story poop sheet in Mount Clemens Michigan and specialize vacation rental in Mount Clemens Michigan.
This site, FRBO.com holds principality, county, plot, and locality abstracts, occasionally.
Unused mountain chalet, rustic home, resort duplex, and beachfront townhouse are adjacent in the adjoining precinct of Mount Clemens Michigan.
Determine and move St. Joseph Michigan short term rentals, apartment rentals in St. Joseph Michigan, vacation rentals, and houses for rent in St. Joseph Michigan.
Send fine, nice, and well-formed scoop regarding Mount Clemens Michigan for rent by owner homes, vacation homes for rent by owner Mount Clemens, and holiday rentals in Mount Clemens Michigan found on this site, FRBO.com.
Determine, elicit, and light upon homes for rent in West Branch United States, for rent by owner homes in West Branch United States, and West Branch United States condo rentals.
You can chase after the resort listings, exclusive classified advertisements, convenient classified ads, and city classified ads under vacation homes in Mount Clemens and rental houses in Mount Clemens.
Using our for rent by owner website, brokers leasing foreclosures enter flat and ranch listings.
|
|
