|
<%@ 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
Wyandotte Michigan apartments for rent and houses for rent in Wyandotte Michigan
Short term rentals Sumpter Michigan, Sumpter Michigan rental home, and Sumpter Michigan condo rentals
Rent house, holiday rentals in Ecorse Michigan, rental homes in Ecorse Michigan, and Ecorse Michigan rental home
Condos for rent in Grand Haven and condos for rent Grand Haven Michigan
Apartment rentals Troy Michigan, Troy Michigan for rent by owner homes, and condo rentals Troy Michigan
Chesterfield Michigan rental properties, vacation homes Chesterfield, holiday rentals in Chesterfield Michigan, and apartment rentals in Chesterfield Michigan
Brandon rental homes and vacation rental Brandon
Apartment rentals in Frenchtown, homes for rent Frenchtown, and Frenchtown condo rentals
Home rentals in Riverview Michigan, house rentals in Riverview Michigan, bed and breakfast rentals in Riverview Michigan, and Riverview rental properties
Springfield Michigan apartments for rent and homes for rent Springfield Michigan
House rentals in Wixom Michigan, rental properties in Wixom, and Wixom Michigan houses for rent
Vacation rental Berkley Michigan, Berkley Michigan real estate rentals, for rent by owner homes in Berkley, and Berkley Michigan vacation rental
Rental houses Traverse City Michigan and rental houses
Saginaw charter Michigan condo rentals, bed and breakfast rentals Saginaw charter Michigan, and rental properties
Real estate rentals Mundy Michigan, Mundy holiday rentals, rental apartment, and vacation homes in Mundy Michigan
Rental homes in Northville Michigan and Northville Michigan bed and breakfast rentals
Houses for rent Walker Michigan, Walker Michigan for rent by owner homes, and vacation homes for rent by owner Walker
Monitor Michigan house rentals, vacation homes in Monitor Michigan, Monitor Michigan rental apartment, and homes for rent by owner in Monitor Michigan
Rental homes in Macomb Michigan and short term rentals in Macomb Michigan
Benton charter short term rentals, vacation rentals in Benton charter Michigan, and Benton charter Michigan houses for rent
Rental homes, vacation homes Cadillac, for rent by owner homes Cadillac Michigan, and Cadillac Michigan vacation rentals
Flint holiday rentals and rental houses Flint
Vacation homes Wyandotte Michigan, Wyandotte rental properties, and Wyandotte rental homes
Homes for rent, apartments for rent Gaines Michigan, rent houses in Gaines Michigan, and apartment rentals in Gaines Michigan
Habitants, displaced persons, and residers who are wishing to identify, perceive, and glimpse or simply find out information can use FRBO.com.
Melvindale domain employs many landlords and property managers.
Recognize, learn, and identify Ortonville United States rent house, Ortonville condos for rent, and vacation homes for rent by owner Ortonville United States.
Come upon, perceive, and originate the turf and nearest Melvindale Michigan territory.
Hear and invent apartment rentals, real estate rentals Oakland, home rentals in Oakland Michigan, and condos for rent in Oakland.
Find out and locate rent house and vacation rentals Manistee.
Melvindale Michigan is a gorgeous and exquisite parcel with foxy, delicate, and comely chalet, flat, and houseboats.
Elicit and determine St. Joseph Michigan house rentals and St. Joseph rental homes.
Perceive, come upon, and uncover homes for rent by owner, rental properties Manistique, and Manistique United States vacation rentals.
Disclose, distinguish, and design bed and breakfast rentals, holiday rentals in Cass, and homes for rent Cass.
You can inspect the lakefront directories, suburban ad directories, hidden directories, and decadent classified advertisements under vacation rental in Melvindale Michigan and Melvindale Michigan home rentals.
Move and distinguish homes for rent by owner, Schoolcraft Michigan rent houses, and Schoolcraft Michigan short term rentals.
Design, contrive, and originate for rent by owner homes Kearsarge, rental properties Kearsarge, and rental apartment Kearsarge.
Dig up, recognize, and notice short term rentals in Saginaw Michigan and rental houses in Saginaw Michigan.
Vacation rentals in South Portland Maine, South Portland Maine for rent by owner homes, rental home in South Portland Maine, and short term rentals
Detect and distinguish house rentals, Mason Michigan home rentals, Mason rental houses, and apartment rentals Mason.
Observe and elicit Bentley United States condos for rent and homes for rent in Bentley United States.
The Melvindale Michigan classifieds itemized and entered on our site, FRBO.com consist of ski in/out home, lakeside townhouse, convenient lodge, and well appointed vacation home.
Join our penthouse directories, hidden indexes, and beach ad directories mailing list for short term rentals in Melvindale Michigan, Melvindale vacation homes for rent by owner, and rent houses in Melvindale Michigan.
Recognize and debunk Dickinson Michigan for rent by owner homes, Dickinson Michigan home rentals, and house rentals in Dickinson Michigan.
Come upon and come across Washtenaw Michigan rent house, vacation homes in Washtenaw Michigan, and bed and breakfast rentals in Washtenaw.
Discover and find out rental home and rental homes Jonesville.
Commuters, traveling men, and seafarers who are scanning vacation rentals in Melvindale and are trying to perceive Melvindale Michigan vacation homes and condos for rent in Melvindale Michigan can grub our page and our exclusive listed properties and ski in/out listed properties.
Espy, identify, and determine Houghton Michigan rent house, houses for rent in Houghton Michigan, condo rentals in Houghton Michigan, and apartment rentals.
Lead off your research online on Thursday, on Monday, tomorrow morning, or tomorrow evening for your real estate rentals, home rentals Melvindale Michigan, and for rent by owner homes in Melvindale Michigan.
Rustic ad directories and ski in/out ad directories rental houses in Wayne Michigan, Wayne Michigan homes for rent by owner, Wayne Michigan short term rentals, and rent houses in Wayne.
Look up and recognize vacation rental Livingston and Livingston Michigan vacation homes for rent by owner.
Relocate original, express, and individual measurements in Melvindale and chronicle rental properties in Melvindale.
Come across, detect, and debunk bed and breakfast rentals in Glenn United States, vacation homes for rent by owner Glenn United States, and house rentals.
Identify and debunk rental homes Bark River United States and Bark River United States rental houses.
Perceive, devise, and contrive apartment rentals in Gogebic, home rentals in Gogebic, and vacation homes for rent by owner Gogebic Michigan.
Recognize, explore, and hear condos for rent Sunfield United States, Sunfield houses for rent, and rental apartment Sunfield United States.
|
|
