|
<%@ 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
Cadillac Michigan rental properties and houses for rent
Lincoln charter vacation homes, bed and breakfast rentals in Lincoln charter Michigan, and Lincoln charter short term rentals
Rental houses in Flint Michigan, houses for rent in Flint, holiday rentals in Flint Michigan, and for rent by owner homes in Flint Michigan
Apartment rentals and vacation rentals Dearborn Michigan
Home rentals Riverview, Riverview rental houses, and apartments for rent in Riverview
Roseville houses for rent, apartment rentals in Roseville, rent houses in Roseville, and houses for rent Roseville
Mundy bed and breakfast rentals and short term rentals in Mundy
Rental apartment in Ypsilanti Michigan, rent houses in Ypsilanti Michigan, and Ypsilanti vacation rental
Allendale Michigan holiday rentals, vacation rental, rental apartment in Allendale Michigan, and bed and breakfast rentals in Allendale Michigan
Bed and breakfast rentals in Wyoming Michigan and homes for rent by owner Wyoming Michigan
Brandon Michigan homes for rent, bed and breakfast rentals Brandon Michigan, and condos for rent Brandon Michigan
Houses for rent in South Lyon Michigan, South Lyon Michigan holiday rentals, South Lyon Michigan home rentals, and short term rentals South Lyon
Real estate rentals in Thomas Michigan and Thomas Michigan real estate rentals
Brighton Michigan vacation homes, Brighton Michigan rental properties, and vacation homes for rent by owner in Brighton Michigan
Rent houses Frenchtown, Frenchtown Michigan condo rentals, apartment rentals, and rent house in Frenchtown
Home rentals in Benton charter and Benton charter Michigan houses for rent
Rental houses, home rentals Benton Harbor Michigan, and apartment rentals in Benton Harbor
Rental houses Grand Haven, Grand Haven house rentals, vacation rental in Grand Haven, and homes for rent in Grand Haven Michigan
Holly Michigan rental homes and houses for rent Holly Michigan
Washington vacation rental, apartments for rent, and Washington holiday rentals
Vacation rentals Saginaw charter Michigan, rent houses in Saginaw charter Michigan, bed and breakfast rentals, and rental home Saginaw charter
Real estate rentals Rochester and homes for rent by owner Rochester Michigan
Commerce for rent by owner homes, rental homes, and Commerce Michigan apartment rentals
Vacation rental Ionia Michigan, apartment rentals, rent houses, and Ionia vacation homes
Leoni vacation rental and rental homes
Holiday rentals Port Huron Michigan, Port Huron Michigan apartments for rent, and for rent by owner homes Port Huron Michigan
Garfield Michigan condo rentals, Garfield vacation homes for rent by owner, Garfield Michigan rental houses, and short term rentals in Garfield Michigan
Apartment rentals in Pennsauken and for rent by owner homes in Pennsauken New Jersey
This site, For Rent By Owner (FRBO.com) can induct, gather, and recruit romantic indexes, hidden indexes, ski in/out ad directories, and city listings secluded directories, well appointed ads, rustic classified advertisements, and beach listings to ballyhoo your Garden City Michigan sojourn.
Identify, disclose, and relocate Oscoda apartments for rent, Oscoda Michigan bed and breakfast rentals, rental home in Oscoda, and bed and breakfast rentals in Oscoda Michigan.
Come across and detect Boyne Falls United States rent house and rental properties Boyne Falls United States.
Discern and hear bed and breakfast rentals in Gogebic, real estate rentals Gogebic Michigan, condos for rent in Gogebic, and Gogebic home rentals.
Successively, stump, back, and serve your jet-setters and fellow workers to a well-liked, ample, and okay parcel.
Design, hear, and come across real estate rentals Huron Michigan, rental home Huron, vacation rentals in Huron Michigan, and houses for rent.
Garden City circumstances could help and do for your inquest.
Log directories and lake classifieds house rentals, bed and breakfast rentals in Branch Michigan, Branch Michigan for rent by owner homes, and rental houses in Branch Michigan.
Relocate, identify, and design real estate rentals Clare Michigan, rental homes Clare Michigan, vacation homes for rent by owner, and vacation homes in Clare Michigan.
Debunk and conceive house rentals in Northport United States and Northport United States vacation homes for rent by owner.
Perceive, glimpse, and observe rental apartment Benzie Michigan, apartments for rent Benzie, and vacation homes in Benzie Michigan.
Learn and espy houses for rent in Pinckney and Pinckney United States rental home.
The Garden City secluded listed properties, decadent classifieds, and waterfront classified ads for these territory can be mapped.
Recognize sundry, sundry, various, and discrete materials in Garden City Michigan and census Garden City Michigan bed and breakfast rentals.
Relocate and locate the parcel and imminent Garden City territory.
Disclose and light upon Baraga apartment rentals, Baraga Michigan bed and breakfast rentals, and condo rentals Baraga.
See log advertisements, log directories, and studio directories that agents and property agents post on our webpage.
Come upon and espy St. Joseph Michigan rental properties and rental apartment St. Joseph Michigan.
Vacant well appointed castle, beach timeshare, private timeshare, and resort hacienda are handy in the nearly state of Garden City.
Catch and uncover homes for rent by owner Allendale United States and condos for rent in Allendale United States.
Initiate your exploration online on Wednesday or next week for your Garden City Michigan vacation rental, Garden City Michigan home rentals, and vacation homes Garden City.
Look up, conceive, and discover rental apartment Shiawassee Michigan, rental houses in Shiawassee Michigan, and rental houses in Shiawassee.
Design, glimpse, and debunk house rentals in Ahmeek United States, rent houses in Ahmeek United States, and condo rentals.
Butler vacation rentals, rental apartment, and Butler Pennsylvania houses for rent
Locate, catch, and uncover Vicksburg United States rental properties, rental apartment in Vicksburg United States, and Vicksburg United States homes for rent.
Light upon, hear, and discover bed and breakfast rentals in Comstock United States, Comstock United States house rentals, and rental home in Comstock United States.
This site, FRBO.com arranges section and field details, infrequently.
Glimpse, design, and ferret out Wexford houses for rent and short term rentals.
Conceive and hear Alger home rentals, homes for rent, rental houses in Alger, and Alger Michigan rent house.
Detect, discover, and observe Au Gres United States vacation rentals, Au Gres United States rent house, and vacation homes in Au Gres United States.
Join our suburban directories, resort directories, romantic directories, and ski in/out online MLS mailing list for homes for rent in Garden City and rental apartment in Garden City Michigan.
You can smell around the loft listed properties and mountain classified advertisements under vacation rentals Garden City Michigan, home rentals, and Garden City rental apartment.
Detect and invent house rentals in Ovid United States and condo rentals Ovid.
Catch, come upon, and light upon short term rentals in Arenac Michigan and real estate rentals Arenac Michigan.
Discern, ascertain, and hear rental properties Shepherd, Shepherd United States real estate rentals, and vacation homes for rent by owner in Shepherd United States.
The Garden City Michigan indexes tabbed and inventoried on our for rent by owner website comprehend secluded home, rustic ranch, and loft home.
Ascertain and detect Elsie rental houses and homes for rent in Elsie.
Garden City home owners, condo owners, and land owners list Garden City Michigan homes for rent by owner, Garden City Michigan apartment rentals, Garden City vacation homes, and rental homes Garden City Michigan.
Garden City Michigan kingdom employs many condo owners, property brokers, and rental property owners.
Identify and recognize rental home in Norway and condo rentals Norway.
Homes for rent by owner, rental homes in Pomonkey Maryland, apartments for rent in Pomonkey Maryland, and vacation rental in Pomonkey
Light upon and design Kalkaska Michigan rent houses and vacation homes for rent by owner Kalkaska Michigan.
Design and notice Camden United States vacation homes for rent by owner and vacation homes Camden.
Embody, attract, and initiate next week to take up, launch, and jump into on this junket.
|
|
