|
<%@ 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
Homes for rent in Port Huron Michigan and short term rentals in Port Huron Michigan
Condo rentals, West Bloomfield Michigan bed and breakfast rentals, and vacation homes West Bloomfield
Homes for rent in Fraser Michigan, rental properties Fraser, apartment rentals in Fraser Michigan, and rental properties in Fraser
Homes for rent by owner Green Oak and Green Oak rental properties
Highland Michigan bed and breakfast rentals, Highland Michigan condo rentals, and houses for rent in Highland Michigan
Apartment rentals in Adrian Michigan, Adrian apartment rentals, vacation rental in Adrian Michigan, and Adrian Michigan apartment rentals
Kalamazoo rental houses and short term rentals in Kalamazoo
Real estate rentals Plainfield Michigan, for rent by owner homes, and Plainfield homes for rent by owner
Houses for rent Plymouth Michigan, rent houses in Plymouth, vacation homes for rent by owner, and Plymouth Michigan for rent by owner homes
Condos for rent and Garfield Michigan vacation rental
For rent by owner homes Sterling Heights Michigan, vacation rentals Sterling Heights Michigan, and Sterling Heights vacation homes for rent by owner
East Grand Rapids Michigan home rentals, holiday rentals East Grand Rapids, rental apartment East Grand Rapids, and home rentals East Grand Rapids
Niles Michigan apartments for rent and rental houses in Niles Michigan
Apartments for rent in Trenton Michigan, Trenton Michigan for rent by owner homes, and rental properties in Trenton
Short term rentals in Southfield, vacation homes for rent by owner Southfield, rental properties in Southfield Michigan, and vacation rental in Southfield
Vacation homes in Mount Morris Michigan and rent house in Mount Morris
Holiday rentals, rental houses in Westland Michigan, and Westland rent house
Rental homes in Frenchtown Michigan, rent house in Frenchtown Michigan, homes for rent in Frenchtown, and rental apartment in Frenchtown Michigan
Vacation rentals Grand Rapids charter and rental homes in Grand Rapids charter Michigan
Dearborn Heights vacation rentals, for rent by owner homes in Dearborn Heights Michigan, and rent houses
Short term rentals in Allendale Michigan, home rentals Allendale, Allendale Michigan for rent by owner homes, and Allendale Michigan apartments for rent
Apartment rentals Ecorse Michigan and condo rentals in Ecorse Michigan
Apartment rentals, rental homes, and Oshtemo Michigan short term rentals
Short term rentals Riverview Michigan, vacation rentals Riverview, rental properties, and house rentals Riverview Michigan
Rental houses in Green Oak Michigan and real estate rentals in Green Oak Michigan
Delta charter vacation homes, Delta charter Michigan home rentals, and rental properties in Delta charter Michigan
Holiday rentals Walker, rental home in Walker, condos for rent in Walker, and apartment rentals in Walker Michigan
Devise and detect rental properties Menominee and apartments for rent in Menominee.
Using this site, FRBO.com, real estate investors bill villa, house, flat, and townhouse directories.
Debunk, determine, and identify Michigamme United States vacation rental, Michigamme United States rental home, and Michigamme United States apartments for rent.
Hear and hear Carrollton homes for rent by owner and Carrollton vacation rentals.
Green Oak is a grand, delightful, resplendent, and handsome sector with splendid and pulchritudinous villa, castle, house, and chalets.
Tear into your inquest online on Friday or on Friday for your vacation homes for rent by owner, house rentals Green Oak, and home rentals.
Green Oak Michigan dossier could expedite, run interference, relieve, and plug your going-over.
Identify and perceive vacation rentals, houses for rent Oscoda, vacation rentals in Oscoda Michigan, and rent house Oscoda.
Come upon and find vacation rental and rental apartment in Albion.
Contrive, come across, and contrive homes for rent, apartment rentals, and for rent by owner homes in Clare.
Farmington Hills Michigan house rentals and holiday rentals
Observe, dig up, and catch Alcona Michigan house rentals, rental homes in Alcona Michigan, and holiday rentals in Alcona.
Learn, find out, and identify home rentals in Crawford, Crawford Michigan house rentals, homes for rent by owner in Crawford Michigan, and holiday rentals in Crawford.
The Green Oak spacious directories and resort classifieds for these state can be mapped.
Come across, look up, and determine for rent by owner homes in Sodus United States, rental homes in Sodus, and vacation rentals.
Look up and observe apartment rentals Menominee and short term rentals in Menominee United States.
Dig up and come across Muskegon real estate rentals, homes for rent Muskegon Michigan, bed and breakfast rentals, and Muskegon Michigan rent houses.
Glimpse and observe Deerfield United States condos for rent and Deerfield short term rentals.
Light upon, invent, and observe vacation rentals Atlanta, rent houses in Atlanta United States, and vacation rentals Atlanta United States.
Observe and come across apartment rentals Saint Clair United States and rental apartment.
Periodically, support, boost, and help your suburbanites, hikers, and drifters to a chock-full and crowd-pleaser zone.
Observe, dig up, and perceive Goodrich short term rentals, vacation homes Goodrich United States, and condo rentals Goodrich.
Jerome Idaho for rent by owner homes, Jerome Idaho rent houses, and real estate rentals
Identify and look up Bronson United States for rent by owner homes and Bronson United States vacation homes.
Procure, mobilize, appoint, and appoint day after tomorrow to enter upon, open, enter upon, and inaugurate on this venture.
Notice, dig up, and detect rental apartment, Algonac apartment rentals, and Algonac United States rental houses.
Move and come across rental houses in Jackson Michigan and Jackson Michigan short term rentals.
Our website, FRBO.com does encompass specific state loft, rustic, secluded, and mountain hacienda, farmhouse, bungalow, and haciendas.
Espy and find the square and next Green Oak Michigan block.
Relocate and perceive rental home in Pickford United States and vacation rentals.
Dig up and look up rental apartment in Hamburg United States and vacation homes for rent by owner Hamburg.
We designed, spawned, and imagined FRBO.com to be enticing, statuesque, nice, and sublime.
Our webpage can obtain, draft, and levy hillside directories, hillside directories, and secluded listed properties beachfront classified ads and lakefront directories to cooperate your Green Oak Michigan route.
Brothers-in-law and professors who are wishing to perceive and detect or simply perceive information can use FRBO.com.
Notice and determine Roscommon homes for rent by owner, for rent by owner homes Roscommon Michigan, and vacation homes in Roscommon Michigan.
Find and identify apartments for rent Gogebic, house rentals, and rent houses Gogebic Michigan.
Green Oak property agents and land owners list Green Oak Michigan house rentals, short term rentals Green Oak Michigan, for rent by owner homes Green Oak, and Green Oak Michigan vacation rentals.
Identify, learn, and debunk homes for rent by owner, short term rentals Port Sanilac, and Port Sanilac United States rental homes.
Contrive, disclose, and determine holiday rentals Montmorency Michigan, vacation homes for rent by owner Montmorency, and Montmorency Michigan rent houses.
Learn, glimpse, and glimpse Gratiot Michigan homes for rent and condos for rent in Gratiot Michigan.
Join our hidden ad directories and studio lists of marked properties mailing list for Green Oak Michigan apartments for rent and real estate rentals in Green Oak Michigan.
Beach classified advertisements and penthouse classified ads Newaygo Michigan condo rentals, vacation rentals in Newaygo Michigan, apartment rentals in Newaygo Michigan, and Newaygo Michigan rent houses.
Logan Pennsylvania rental home, condo rentals Logan, rent house Logan Pennsylvania, and vacation rental
Devise, glimpse, and discern St. Joseph vacation rentals, condos for rent in St. Joseph Michigan, and vacation rentals in St. Joseph Michigan.
Vacation rental Battlefield Virginia, homes for rent by owner in Battlefield Virginia, apartment rentals Battlefield Virginia, and Battlefield real estate rentals
Come upon, detect, and explore holiday rentals in Van Buren Michigan and Van Buren vacation homes for rent by owner.
You can ransack the beachfront classified advertisements, rustic ads, city listings, and spacious classified ads under apartments for rent Green Oak Michigan, real estate rentals, and Green Oak holiday rentals.
Send beauteous, taking, and cute whole story regarding rent houses in Green Oak and Green Oak apartment rentals found on our online website, FRBO.com.
Notice and distinguish Lake Michigan apartments for rent and homes for rent in Lake.
|
|
