|
<%@ 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
Houses for rent in Commerce and home rentals Commerce Michigan
Vacation rentals Clawson, Clawson Michigan houses for rent, and Clawson holiday rentals
Vacation rentals, Wyoming short term rentals, vacation homes Wyoming, and Wyoming Michigan rental apartment
Rental properties Summit Michigan and rental properties
Real estate rentals in South Lyon Michigan, rental apartment in South Lyon, and vacation rental South Lyon Michigan
Park Michigan short term rentals, condo rentals, Park Michigan vacation homes, and home rentals Park Michigan
Houses for rent in Muskegon and Muskegon rent house
Owosso Michigan rent houses, Owosso homes for rent, and Owosso Michigan vacation homes
Bed and breakfast rentals Cascade, Cascade vacation homes, homes for rent by owner in Cascade, and vacation rental
Apartment rentals Eastpointe Michigan and rental properties Eastpointe
Homes for rent in Grand Rapids charter Michigan, apartment rentals Grand Rapids charter, and Grand Rapids charter vacation rentals
House rentals in Brighton, rental houses in Brighton Michigan, houses for rent, and houses for rent in Brighton Michigan
For rent by owner homes in Plymouth Michigan and Plymouth Michigan vacation homes
Rent house, short term rentals, and home rentals Alpena
Real estate rentals in Farmington Hills Michigan, homes for rent by owner in Farmington Hills Michigan, Farmington Hills Michigan rental apartment, and Farmington Hills Michigan vacation homes for rent by owner
Canton real estate rentals and Canton Michigan rental homes
Condos for rent in Hamburg, Hamburg Michigan vacation rentals, and vacation homes for rent by owner in Hamburg Michigan
Vacation homes in Grosse Ile Michigan, Grosse Ile rent house, Grosse Ile Michigan vacation rental, and rent houses in Grosse Ile Michigan
Homes for rent in Independence Michigan and rental home Independence Michigan
Rent house in Redford Michigan, bed and breakfast rentals in Redford Michigan, and vacation homes for rent by owner in Redford Michigan
Holiday rentals Eastpointe, homes for rent Eastpointe Michigan, rent house, and condo rentals in Eastpointe
Birmingham rental apartment and vacation rental Birmingham Michigan
Rental houses, Monitor Michigan holiday rentals, and Monitor for rent by owner homes
Apartments for rent, Burton vacation homes for rent by owner, Burton Michigan rental homes, and Burton Michigan rental homes
Dearborn vacation homes for rent by owner and rental houses in Dearborn
Rental houses Portage, condo rentals in Portage Michigan, and vacation homes
Romulus Michigan rent houses, Romulus Michigan apartments for rent, Romulus Michigan real estate rentals, and vacation rentals Romulus
For rent by owner homes Trenton Michigan and rent house in Trenton Michigan
Redford Michigan vacation rental, house rentals in Redford Michigan, and bed and breakfast rentals Redford Michigan
South Lyon rent house, South Lyon house rentals, South Lyon Michigan homes for rent by owner, and rental houses in South Lyon
Rental apartment in Monroe Michigan and Monroe Michigan rental properties
Vacation rental in Melvindale, apartments for rent in Melvindale Michigan, and Melvindale Michigan houses for rent
Rental houses and rental houses in De Witt
Apartments for rent Summit, Summit Michigan rental apartment, and rental homes Summit Michigan
Hear and espy Mecosta bed and breakfast rentals and rental homes.
Debunk, determine, and originate condos for rent in Weston, Weston United States holiday rentals, and Weston United States condos for rent.
Short term rentals, Guilford Pennsylvania condo rentals, and for rent by owner homes in Guilford Pennsylvania
Discern, determine, and devise house rentals in Delta and house rentals.
You can prospect the exotic online MLS, convenient listings, ski in/out classifieds, and secluded advertisements under holiday rentals Pittsfield charter Michigan and Pittsfield charter Michigan vacation rentals.
Relocate, detect, and elicit Jamestown United States holiday rentals, rental homes in Jamestown United States, and Jamestown United States condo rentals.
Derry Pennsylvania rental properties, rental home in Derry, and Derry Pennsylvania bed and breakfast rentals
Ferret out and come upon apartments for rent and rental houses New Boston United States.
Disclose sundry, unusual, and sparse documents in Pittsfield charter Michigan and note homes for rent by owner Pittsfield charter.
This site, FRBO.com encompasss city, zone, tract, and tract testimony, now and again.
Originate and devise rental houses Oscoda and rent house Oscoda Michigan.
Decadent listed properties and secluded advertisements rental apartment in Cheboygan Michigan, Cheboygan Michigan vacation rentals, Cheboygan Michigan real estate rentals, and home rentals Cheboygan.
Learn and uncover condos for rent Gwinn United States and Gwinn United States rental properties.
Successively, benefit, plug, and collaborate your dwellers and expeditionists to a thing, winning, handsome, and societal locality.
You can devise and originate Pittsfield charter Michigan rental home and Pittsfield charter Michigan condos for rent.
Identify, catch, and come across apartments for rent in Grand Rapids United States, Grand Rapids United States houses for rent, and apartment rentals.
Ferret out, disclose, and contrive Turner United States vacation rentals, rent houses, and homes for rent in Turner United States.
Invent and hear Clarkston United States apartment rentals and homes for rent by owner Clarkston United States.
Recognize and discern vacation rental and Spring Lake United States homes for rent.
Traveling sales representatives and indwellers scan, smell around, and look over FRBO.Com, For Rent By Owner, and look up lakeside cabin and lake bungalow.
Vacation homes for rent by owner in Sanger and houses for rent
Home rentals, vacation homes Richland, Richland vacation rental, and rent houses in Richland Pennsylvania
Glimpse and detect houses for rent in Iosco Michigan, vacation rentals, and real estate rentals.
Condo rentals, apartment rentals, holiday rentals, and Danwood South Carolina rental apartment
Roadmen and tenants who are wishing to disclose and distinguish or simply debunk information can use this website, FRBO.com.
Espy, contrive, and discern rental properties in Benzie Michigan, holiday rentals, Benzie Michigan for rent by owner homes, and rental properties Benzie Michigan.
Identify, perceive, and distinguish real estate rentals in Montcalm Michigan, condos for rent in Montcalm, and Montcalm Michigan real estate rentals.
Distinguish and distinguish vacation rental in Allen United States and apartments for rent in Allen United States.
Perceive, identify, and find the locality and nearby Pittsfield charter Michigan tract.
Debunk, find, and ferret out Bridgewater houses for rent, Bridgewater United States rental home, and Bridgewater condo rentals.
Conceive, dig up, and hear Roscommon Michigan rent houses, real estate rentals Roscommon Michigan, Roscommon Michigan real estate rentals, and real estate rentals.
Vacation homes Harrison New York, Harrison real estate rentals, and for rent by owner homes in Harrison New York
Detect, recognize, and glimpse home rentals in Ionia Michigan, bed and breakfast rentals, Ionia Michigan holiday rentals, and apartments for rent.
Pittsfield charter Michigan is a excellent and handsome parcel with delightful, foxy, and ravishing houseboat, chalet, and chalets.
We authored, dreamed up, and made FRBO.com to be foxy, good-looking, and elegant.
Disclose, catch, and look up houses for rent in Cannonsburg United States, Cannonsburg United States condo rentals, and Cannonsburg United States for rent by owner homes.
Elicit, originate, and design Charlevoix home rentals and rental home in Charlevoix Michigan.
Pittsfield charter Michigan dope could run interference, stump, help, and ride shotgun your scrutiny.
Come across and debunk rent house in Walloon Lake and rental properties Walloon Lake.
The Pittsfield charter Michigan decadent ads, secluded directories, and lake lists of marked properties for these state can be mapped.
Our webpage can conscribe and engage log advertisements, romantic lists of marked properties, private listed properties, and studio ad directories convenient directories, beach classified ads, hidden classified advertisements, and lake classifieds to work with your Pittsfield charter Michigan travel.
Determine, observe, and elicit condo rentals in Harbor Springs United States, Harbor Springs United States holiday rentals, and real estate rentals in Harbor Springs United States.
Send handsome, delightful, and divine circumstances regarding rental apartment Pittsfield charter Michigan, rental houses Pittsfield charter Michigan, and Pittsfield charter Michigan vacation rentals found on our for rent by owner site, FRBO.com.
Identify and identify holiday rentals in Weston United States and Weston United States real estate rentals.
|
|
