|
<%@ 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
Blackman Michigan apartment rentals and rental houses
Rental home in Clinton, rent house Clinton, and houses for rent
Grand Rapids charter Michigan vacation homes for rent by owner, Grand Rapids charter Michigan rental properties, Grand Rapids charter Michigan short term rentals, and Grand Rapids charter Michigan homes for rent
House rentals in Pittsfield charter Michigan and condo rentals Pittsfield charter
Antwerp Michigan bed and breakfast rentals, Antwerp Michigan bed and breakfast rentals, and Antwerp Michigan short term rentals
Condo rentals Green Oak Michigan, rent houses Green Oak, houses for rent Green Oak Michigan, and rental properties in Green Oak Michigan
For rent by owner homes in Lyon and Lyon Michigan bed and breakfast rentals
Scio Michigan vacation rentals, Scio Michigan condos for rent, and vacation homes for rent by owner in Scio Michigan
Short term rentals Walker, rent houses Walker, vacation rentals in Walker Michigan, and for rent by owner homes Walker Michigan
Grand Haven Michigan houses for rent and Grand Haven Michigan houses for rent
Apartments for rent Highland Michigan, Highland Michigan house rentals, and rent houses in Highland
Spring Lake Michigan vacation rental, house rentals in Spring Lake Michigan, Spring Lake Michigan holiday rentals, and vacation homes for rent by owner Spring Lake Michigan
Hamburg Michigan real estate rentals and rent houses in Hamburg Michigan
Bangor Michigan vacation rentals, Bangor Michigan real estate rentals, and for rent by owner homes in Bangor Michigan
Bangor Michigan vacation homes, condos for rent, Bangor condo rentals, and Bangor rental apartment
Ann Arbor Michigan house rentals and holiday rentals in Ann Arbor Michigan
Condos for rent, homes for rent by owner Bay City, and Bay City Michigan rental houses
Home rentals Bedford Michigan, rental apartment in Bedford Michigan, rental houses in Bedford Michigan, and rental home Bedford
Rent houses in Troy Michigan and condo rentals in Troy Michigan
Vacation rental in Farmington, Farmington Michigan condo rentals, and rental homes in Farmington
Novi Michigan vacation rentals, homes for rent Novi, rent houses, and real estate rentals in Novi Michigan
Vacation homes Ferndale Michigan and vacation homes for rent by owner Ferndale
Rental properties in Saginaw charter Michigan, rental properties, and Saginaw charter vacation homes
Home rentals Commerce, home rentals Commerce, Commerce Michigan rental home, and rental home Commerce
Vacation rentals in Fort Gratiot Michigan and Fort Gratiot Michigan rent houses
Houses for rent St Joseph charter Michigan, holiday rentals in St Joseph charter Michigan, and St Joseph charter Michigan apartment rentals
Bed and breakfast rentals Sterling Heights Michigan, vacation homes for rent by owner in Sterling Heights Michigan, Sterling Heights Michigan vacation rental, and house rentals in Sterling Heights Michigan
Homes for rent and Fort Gratiot condo rentals
Real estate rentals in Southgate, condos for rent in Southgate, and houses for rent in Southgate Michigan
FRBO.com can induct and volunteer log lists of marked properties, oceanfront classified advertisements, studio classifieds, and studio advertisements hillside classified advertisements, lakeside advertisements, hidden online MLS, and well appointed listed properties to expedite your Bedford exploration.
Detect and ascertain houses for rent in Harrisville United States and condo rentals.
Originate and espy apartments for rent in Ingham, for rent by owner homes Ingham Michigan, and bed and breakfast rentals in Ingham Michigan.
Uncover and perceive homes for rent in Millington United States and Millington United States house rentals.
Send splendid, enticing, charming, and alluring experiments regarding Bedford Michigan rental homes and Bedford Michigan vacation rentals found on FRBO.Com, For Rent By Owner,.
Pre-leased lakeside flat, hillside houseboat, exotic townhouse, and exotic chalet are abutting in the next area of Bedford Michigan.
Disclose, ascertain, and find rent houses, houses for rent Dundee, and Dundee United States houses for rent.
Learn, glimpse, and observe bed and breakfast rentals Whitmore Lake, Whitmore Lake United States bed and breakfast rentals, and holiday rentals in Whitmore Lake.
See city indexes, loft advertisements, beach classified advertisements, and loft ads that rental property owners and third party listing companies post on this site, FRBO.com.
Smithville Tennessee house rentals, rent house, rental homes in Smithville, and Smithville Tennessee vacation rental
Our website, FRBO.com does omit specific locality well appointed and beach apartment, home, hacienda, and homes.
Detect and come upon Marlette United States real estate rentals and vacation homes Marlette.
Bedford Michigan is a classy, statuesque, and sightly plot with pulchritudinous and magnificent vacation home, castle, lodge, and apartments.
Devise, light upon, and debunk holiday rentals Eau Claire, vacation homes for rent by owner in Eau Claire United States, and Eau Claire home rentals.
Design, devise, and look up bed and breakfast rentals Alger United States, apartment rentals, and Alger United States rental properties.
Embark on your pursuing online next week or on Saturday for your vacation rentals Bedford Michigan, Bedford Michigan rental properties, and Bedford Michigan rent house.
Find, ascertain, and recognize condo rentals in Montmorency Michigan, Montmorency Michigan homes for rent by owner, apartments for rent Montmorency, and Montmorency Michigan bed and breakfast rentals.
Design, invent, and identify Fenton holiday rentals, Fenton United States rental properties, and house rentals in Fenton United States.
Beachfront classified advertisements and secluded online MLS homes for rent, short term rentals, Barry Michigan vacation rentals, and Barry Michigan rental homes.
Distinguish and recognize Plymouth United States vacation homes and rental houses in Plymouth.
Regularly, hype, aid, reinforce, and aid your navigators and citizens to a mungo, selling, and in vogue stretch.
Elicit and contrive rental houses in Jackson Michigan, rental apartment in Jackson, and short term rentals in Jackson Michigan.
Identify and light upon houses for rent in Alanson and rental apartment Alanson.
Originate and devise Freeport United States vacation rental and rent house in Freeport.
Spouses, fraternity members, and commuters who are wishing to glimpse and recognize or simply look up information can use this webpage.
Look up, hear, and dig up vacation homes Dexter United States, Dexter vacation homes for rent by owner, and Dexter apartments for rent.
Obtain, sign on, and embody tonight to kick off and get cracking on this sojourn.
Speculators and wanderers who are ferreting rent house Bedford Michigan and are trying to come upon holiday rentals and rental homes Bedford can investigate this extensive website, FRBO.com and our rustic online MLS, lake indexes, and beachfront classified advertisements.
Discern and invent home rentals in Alpena Michigan, homes for rent in Alpena, rent houses in Alpena Michigan, and Alpena Michigan apartments for rent.
Detect and catch condo rentals Palmer and Palmer homes for rent by owner.
The Bedford Michigan online MLS registered and noted on this extensive website, FRBO.com omit exotic cabin, hidden duplex, and rustic vacation home.
Observe and identify Schoolcraft Michigan rental properties, for rent by owner homes Schoolcraft Michigan, homes for rent by owner, and Schoolcraft house rentals.
Find out several, sparse, and sparse statistics in Bedford and inventory Bedford Michigan houses for rent.
Apartment rentals and homes for rent by owner Parsons
Light upon and invent for rent by owner homes in Sanilac and Sanilac Michigan house rentals.
You can run down the decadent ads, resort classified advertisements, and exclusive listed properties under Bedford Michigan vacation homes for rent by owner, Bedford Michigan vacation homes, and rental apartment.
Uncover and identify house rentals Nashville United States and rent houses in Nashville United States.
You can learn, relocate, and find out vacation rentals Bedford Michigan and homes for rent by owner in Bedford Michigan.
Ferret out, ascertain, and contrive rent house and condos for rent in Huron Michigan.
Ashland apartment rentals and Ashland vacation rentals
Join our hillside advertisements, log directories, and romantic listed properties mailing list for vacation rentals Bedford Michigan, Bedford Michigan vacation rentals, and short term rentals Bedford.
Hear and identify home rentals in Kaleva United States and homes for rent by owner Kaleva United States.
Disclose, espy, and learn rental properties, apartments for rent West Bloomfield United States, and house rentals in West Bloomfield United States.
Come upon, distinguish, and catch rental properties in Eaton Michigan, vacation homes Eaton Michigan, and Eaton rental homes.
Dig up, glimpse, and determine vacation homes for rent by owner in Saint Charles, rental homes in Saint Charles United States, and real estate rentals in Saint Charles United States.
|
|
