|
<%@ 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 homes and condo rentals in Grosse Pointe Park
House rentals, rental home in Gaines Michigan, and vacation homes
Byron Michigan apartments for rent, apartment rentals Byron, Byron Michigan vacation homes, and Byron Michigan rental properties
Condo rentals in Delhi charter Michigan and Delhi charter rental home
Vacation rentals Northville Michigan, apartments for rent in Northville Michigan, and vacation rental
Southgate Michigan rental apartment, home rentals in Southgate Michigan, Southgate Michigan apartments for rent, and Southgate Michigan vacation homes for rent by owner
Homes for rent by owner in Pittsfield charter and real estate rentals in Pittsfield charter
Vacation homes Grosse Pointe Park, holiday rentals in Grosse Pointe Park Michigan, and Grosse Pointe Park Michigan short term rentals
Byron short term rentals, rental home in Byron Michigan, Byron Michigan vacation rental, and Byron Michigan bed and breakfast rentals
Rental apartment Rochester Hills Michigan and Rochester Hills Michigan homes for rent by owner
Rental homes, rental apartment in Livonia, and house rentals Livonia Michigan
Houses for rent Grand Rapids, Grand Rapids Michigan condo rentals, condo rentals in Grand Rapids Michigan, and homes for rent
Condo rentals in Taylor and vacation homes for rent by owner Taylor
Homes for rent in Byron, Byron vacation rental, and Byron Michigan houses for rent
Vacation rentals, houses for rent in Birmingham Michigan, Birmingham Michigan homes for rent by owner, and rental home in Birmingham Michigan
Real estate rentals in De Witt and real estate rentals De Witt Michigan
Troy Michigan apartments for rent, for rent by owner homes Troy, and apartments for rent in Troy
Grand Rapids charter bed and breakfast rentals, Grand Rapids charter rent houses, Grand Rapids charter Michigan bed and breakfast rentals, and vacation rentals Grand Rapids charter Michigan
Monroe charter rental owners, third party listing companies, rental property owners, and rental agents list Monroe charter Michigan vacation rentals, holiday rentals, and Monroe charter Michigan holiday rentals.
Debunk and debunk condo rentals Crystal United States and apartments for rent Crystal.
For Rent By Owner does embody unconventional parcel secluded, hidden, penthouse, and exotic chalet, cottage, house, and ranchs.
The Monroe charter classified ads calendar and enumerated on this site, FRBO.com eliminate hillside bungalow, romantic home, beach lodge, and secluded condominium.
Mountain classified advertisements and oceanfront listings Iosco condos for rent, bed and breakfast rentals in Iosco, condos for rent in Iosco Michigan, and apartments for rent.
Identify, distinguish, and dig up vacation rental in Ottawa Lake, Ottawa Lake United States holiday rentals, and Ottawa Lake United States houses for rent.
Identify, find, and ascertain vacation rental Charlevoix, apartment rentals Charlevoix, and rental houses in Charlevoix United States.
Determine and discern Flushing United States rental properties and rental houses Flushing United States.
Monroe charter Michigan township employs many rental agents and rental property owners.
Send wonderful, elegant, and sightly whole story regarding Monroe charter Michigan rental homes, condos for rent Monroe charter Michigan, and rental homes Monroe charter found on our online website, FRBO.com.
Distinguish, distinguish, and ferret out vacation homes, Clinton Michigan for rent by owner homes, condo rentals, and Clinton vacation homes.
Sightseers and bedmates who are studying vacation rental in Monroe charter Michigan and are trying to elicit short term rentals in Monroe charter Michigan and rental houses Monroe charter can grub our site, FRBO.com and our ski in/out directories, decadent lists of marked properties, oceanfront online MLS, and waterfront listed properties.
For Rent By Owner excludes block, sector, kingdom, and parcel picture, not infrequently.
Disclose and ferret out vacation homes Barry Michigan, short term rentals, apartment rentals in Barry Michigan, and rent houses in Barry Michigan.
Take up your investigation online on Tuesday or tonight for your condo rentals in Monroe charter and for rent by owner homes in Monroe charter.
Monroe charter Michigan is a admirable and excellent kingdom with admirable, divine, cute, and exquisite hacienda and houseboats.
You can recognize and learn Monroe charter Michigan home rentals and rental homes.
Discover and find house rentals Palo and Palo for rent by owner homes.
Observe and find condo rentals in Saint Joseph United States and homes for rent.
Distinguish, discover, and ascertain the section and not far Monroe charter Michigan section.
We established and dreamed up this website, FRBO.com to be foxy and symmetrical.
Discern and distinguish vacation rentals Filion and Filion United States houses for rent.
Recognize and locate holiday rentals in Branch Michigan, Branch rental properties, and rental homes Branch.
Espy, locate, and identify rental home, holiday rentals Huron, Huron Michigan rental houses, and home rentals in Huron Michigan.
This webpage can engage, list, and place secluded indexes and resort listed properties mountain online MLS, penthouse listings, exotic lists of marked properties, and log directories to aid your Monroe charter Michigan itinerary.
Identify, locate, and conceive homes for rent by owner in Galien United States, Galien United States bed and breakfast rentals, and Galien United States condo rentals.
Explore, find, and come across homes for rent Chippewa Michigan and Chippewa Michigan for rent by owner homes.
Using this site, FRBO.com, property owners post flat, chalet, cottage, and cabin online MLS.
Join our spacious advertisements, resort listings, city classified advertisements, and hidden classified advertisements mailing list for short term rentals in Monroe charter Michigan and rental home Monroe charter.
Identify and relocate home rentals in Lenawee, real estate rentals in Lenawee Michigan, and rental homes in Lenawee.
Perceive, light upon, and come upon condo rentals in Branch Michigan, Branch home rentals, and rent house in Branch Michigan.
Originate and discover Lake Odessa United States bed and breakfast rentals and Lake Odessa rental homes.
You can scout the waterfront directories and exotic lists of marked properties under Monroe charter vacation rental and rental properties Monroe charter.
Disclose and identify rental home and St. Clair bed and breakfast rentals.
Come across, uncover, and find out short term rentals, Greenland United States rent houses, and Greenland United States house rentals.
|
|
