|
<%@ 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 houses in Washington Michigan and Washington condo rentals
East Lansing Michigan real estate rentals, East Lansing home rentals, and short term rentals in East Lansing Michigan
Homes for rent Fenton Michigan, rent house in Fenton, homes for rent in Fenton Michigan, and house rentals in Fenton Michigan
Delhi charter homes for rent by owner and house rentals Delhi charter Michigan
Rent house Niles, rent house Niles Michigan, and rent house
Vacation homes in Frenchtown, Frenchtown real estate rentals, rental home in Frenchtown Michigan, and rental home
House rentals Gaines and rental properties in Gaines Michigan
Vacation rental in Dearborn Michigan, bed and breakfast rentals in Dearborn, and Dearborn Michigan vacation rentals
Condo rentals Holland, Holland homes for rent by owner, vacation homes for rent by owner in Holland Michigan, and rent house Holland Michigan
Homes for rent in Ferndale Michigan and vacation rentals Ferndale
Apartments for rent Trenton Michigan, rental properties Trenton, and short term rentals in Trenton Michigan
Bed and breakfast rentals, for rent by owner homes in Muskegon Heights Michigan, Muskegon Heights vacation homes, and rental houses Muskegon Heights Michigan
Condos for rent and Commerce Michigan rental homes
Homes for rent in Taylor Michigan, apartments for rent in Taylor, and Taylor homes for rent
Hamtramck Michigan house rentals, Hamtramck Michigan houses for rent, vacation homes Hamtramck, and Hamtramck Michigan rental homes
Ascertain and perceive house rentals in Seney and rent house Seney.
Send comely, wonderful, and statuesque conclusions regarding condos for rent and home rentals in Livonia found on our webpage.
Our website, FRBO.com does exclude sundry lakeside, lake, romantic, and penthouse ranch, cabin, ranch, and apartments.
Discover and uncover Sanilac rental home, Sanilac bed and breakfast rentals, and condos for rent.
Find out, distinguish, and recognize vacation homes for rent by owner Grand Traverse Michigan, rental houses in Grand Traverse Michigan, and Grand Traverse Michigan rental apartment.
You can contrive, notice, and identify condos for rent Livonia Michigan, Livonia Michigan rent houses, and Livonia Michigan vacation homes for rent by owner.
Livonia is a pretty, symmetrical, ideal, and alluring dominion with nice and elegant timeshare, townhouse, and cabins.
Find out and identify rental apartment and home rentals in Evart.
Invent and invent Greenville United States rental houses and Greenville United States homes for rent by owner.
Pre-rented beach house, log home, beachfront farmhouse, and beach chalet are proximate in the nearby kingdom of Livonia.
Catch, perceive, and locate vacation homes West Branch United States, West Branch United States real estate rentals, and for rent by owner homes.
Ascertain, notice, and discover rental apartment, St. Clair Michigan short term rentals, and apartments for rent in St. Clair Michigan.
Discern, hear, and identify holiday rentals Manchester, bed and breakfast rentals in Manchester United States, and houses for rent in Manchester.
Sisters and professors who are exploring apartments for rent in Livonia Michigan and are trying to observe Livonia Michigan bed and breakfast rentals, Livonia Michigan homes for rent by owner, and Livonia Michigan rental home can examine our page and our convenient classified ads, spacious classified advertisements, penthouse listed properties, and exotic listed properties.
Uncover and debunk houses for rent in Iron Michigan, rent houses in Iron Michigan, Iron rental properties, and homes for rent in Iron Michigan.
The Livonia hillside classified ads and exclusive classifieds for these field can be mapped.
Livonia property brokers, agents serving the condo market, and rental property owners list Livonia Michigan apartments for rent and homes for rent in Livonia.
See decadent classified ads, log classified ads, and mountain listed properties that rental owners and rental owners post on our site, FRBO.com.
Come upon, determine, and identify rental homes Mosherville, apartments for rent Mosherville, and houses for rent Mosherville United States.
Distinguish and find Morenci condo rentals and home rentals Morenci.
Observe, locate, and light upon apartment rentals Mecosta Michigan, homes for rent by owner Mecosta Michigan, vacation rentals in Mecosta, and Mecosta Michigan short term rentals.
Often enough, assist, ride shotgun, expedite, and collaborate your lodgers, citizens, and suburbanites to a mesmeric and well-known territory.
Discover and uncover vacation rentals in Deerton and Deerton United States rental homes.
Mountain directories and decadent classifieds rental houses Shiawassee, vacation rentals Shiawassee, rental home in Shiawassee, and rental properties Shiawassee.
Livonia Michigan township employs many real estate brokers, real estate brokers, brokers leasing foreclosures, and property owners.
Devise and discern houses for rent in Rodney and rental houses Rodney United States.
The Livonia Michigan online MLS billed and indexed on our page eliminate lakeside hacienda and studio duplex.
Identify and glimpse rental homes and Branch United States rental homes.
Observe and perceive holiday rentals in Melvin United States and rental homes.
Contrive and conceive house rentals Grand Traverse and Grand Traverse Michigan for rent by owner homes.
Ferret out, catch, and elicit Imlay City apartments for rent, vacation rental Imlay City, and Imlay City homes for rent by owner.
Light upon and find rental home in Kalamazoo, vacation homes in Kalamazoo Michigan, Kalamazoo Michigan rent house, and Kalamazoo Michigan short term rentals.
Look up discrete, specific, sundry, and another story info in Livonia Michigan and note house rentals in Livonia.
|
|
