|
<%@ 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 in Woodhaven Michigan and rental houses
Rental homes in Hartland Michigan, condo rentals Hartland, and apartments for rent in Hartland Michigan
Homes for rent in Wixom Michigan, rental apartment in Wixom Michigan, vacation homes in Wixom Michigan, and Wixom apartment rentals
Rental properties in Taylor Michigan and rental houses in Taylor
Park Michigan vacation homes, for rent by owner homes Park Michigan, and rent house in Park Michigan
Allendale Michigan bed and breakfast rentals, homes for rent by owner in Allendale Michigan, Allendale Michigan rental properties, and Allendale Michigan vacation homes for rent by owner
Vacation rental Mount Clemens Michigan and rent houses in Mount Clemens
Homes for rent in Fenton Michigan, Fenton vacation rental, and Fenton Michigan for rent by owner homes
Homes for rent in Wixom Michigan, Wixom Michigan house rentals, apartments for rent, and Wixom rental properties
Flushing house rentals and Flushing Michigan vacation homes for rent by owner
For rent by owner homes in Inkster Michigan, Inkster Michigan homes for rent, and Inkster for rent by owner homes
Bed and breakfast rentals in Mount Pleasant, house rentals Mount Pleasant Michigan, vacation homes Mount Pleasant Michigan, and vacation rental in Mount Pleasant Michigan
Rent house in Holland and condo rentals in Holland
Grosse Ile homes for rent, condo rentals in Grosse Ile Michigan, and apartment rentals Grosse Ile Michigan
Rent house in Fenton Michigan, Fenton Michigan house rentals, rental apartment, and Fenton Michigan vacation rentals
Houses for rent in Burton Michigan and Burton Michigan rent house
Rental home in St Clair Shores Michigan, vacation homes in St Clair Shores Michigan, and vacation rentals in St Clair Shores Michigan
Rental home Bedford Michigan, rental home Bedford, Bedford house rentals, and homes for rent
Vacation homes Royal Oak and vacation homes for rent by owner in Royal Oak Michigan
Rental home, East Grand Rapids Michigan holiday rentals, and apartments for rent East Grand Rapids Michigan
For rent by owner homes in Oshtemo Michigan, homes for rent by owner in Oshtemo Michigan, Oshtemo Michigan vacation rentals, and Oshtemo Michigan apartment rentals
Homes for rent Springfield Michigan and homes for rent
De Witt Michigan holiday rentals, vacation rental in De Witt Michigan, and De Witt vacation homes
Vacation homes for rent by owner in Davison Michigan, Davison Michigan home rentals, Davison Michigan real estate rentals, and Davison Michigan condos for rent
Holly vacation rental and rental homes in Holly Michigan
Rent houses in Harper Woods Michigan, vacation homes for rent by owner in Harper Woods, and condo rentals Harper Woods
Short term rentals in Wixom Michigan, Wixom Michigan vacation rental, Wixom houses for rent, and rental properties Wixom
Contrive, uncover, and invent Lake Orion United States condo rentals, Lake Orion United States holiday rentals, and rent houses in Lake Orion United States.
Join our exclusive ads and beachfront indexes mailing list for Warren apartment rentals, Warren Michigan rental houses, and rent house in Warren Michigan.
Elicit and determine apartments for rent in Wixom and vacation rentals Wixom United States.
Notice and contrive for rent by owner homes Oakley United States and Oakley houses for rent.
Romantic ad directories and romantic lists of marked properties Washtenaw house rentals, rental homes Washtenaw, rent house in Washtenaw Michigan, and home rentals in Washtenaw Michigan.
Light upon, invent, and ferret out Johannesburg apartments for rent, rental apartment Johannesburg United States, and house rentals in Johannesburg.
Determine and relocate rental homes La Salle United States and La Salle United States for rent by owner homes.
Recurrently, root for, abet, open doors, and expedite your speculators and sorority sisters to a colossal and lovable township.
Distinguish and detect holiday rentals in Kent Michigan, vacation rentals Kent, and bed and breakfast rentals.
The Warren Michigan hillside lists of marked properties and resort advertisements for these zone can be mapped.
Invent and determine the township and impending Warren sector.
This site, FRBO.com does comprise sparse state romantic, spacious, lake, and beach villa, flat, lodge, and castles.
Hear and come across Washtenaw apartment rentals, homes for rent in Washtenaw Michigan, Washtenaw Michigan holiday rentals, and rent houses.
Jet-setters and navigators who are wishing to move, catch, and learn or simply hear information can use FRBO.com.
Originate, contrive, and recognize Lawton United States rent houses, Lawton United States condos for rent, and house rentals Lawton.
Subordinates, itinerants, and jet-setters who are hunting for vacation rentals Warren Michigan and are trying to originate vacation rental in Warren Michigan and Warren condos for rent can scan our for rent by owner website and our beach listings, studio classified advertisements, loft classifieds, and resort listings.
Light upon, light upon, and hear Riverdale United States rent house, condo rentals, and rental homes in Riverdale United States.
Explore, invent, and contrive West Branch United States rental homes, apartments for rent West Branch, and real estate rentals West Branch.
Come upon and discover holiday rentals in Kentwood United States and rental houses in Kentwood.
Warren Michigan is a sublime, alluring, excellent, and appealing kingdom with nice, alluring, and fair ranch, duplex, and timeshares.
Send superb, cute, and delightful documents regarding Warren homes for rent by owner and real estate rentals Warren Michigan found on our website, FRBO.com.
Find out, move, and uncover Alger condo rentals, bed and breakfast rentals in Alger Michigan, and Alger Michigan vacation rental.
For rent by owner homes Valle and holiday rentals in Valle
Distinguish, distinguish, and elicit rental homes Gladwin and condo rentals.
Distinguish, elicit, and contrive St. Clair Michigan rent houses, St. Clair Michigan homes for rent by owner, St. Clair condos for rent, and rent houses in St. Clair.
Elicit and glimpse Kalkaska Michigan rent houses and rental apartment in Kalkaska Michigan.
Conscribe and volunteer on Friday to jump into, lead off, and take up on this vagabondage.
Douglas rental home, vacation homes Douglas Georgia, for rent by owner homes Douglas Georgia, and rent house
Our webpage incorporates vicinity, plot, dominion, and turf goods, now and again.
You can uncover and devise for rent by owner homes Warren Michigan and rental houses in Warren Michigan.
Detect and detect Presque Isle Michigan rental properties, Presque Isle real estate rentals, and apartments for rent in Presque Isle Michigan.
Perceive and look up home rentals, bed and breakfast rentals Emmet, rental homes in Emmet Michigan, and home rentals Emmet Michigan.
Find out, detect, and come upon rental homes, rental houses Mackinaw City, and Mackinaw City United States condos for rent.
Identify, ferret out, and contrive vacation rentals in Berrien Michigan and rental houses.
Glimpse, come upon, and relocate house rentals Pompeii, Pompeii United States vacation rentals, and Pompeii rental homes.
Find and ferret out vacation homes for rent by owner Omena United States and rental properties.
|
|
