|
<%@ 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
Vacation homes for rent by owner in Davison Michigan and short term rentals Davison
Home rentals in Troy Michigan, real estate rentals in Troy Michigan, and vacation rental
Rental houses in Westland, condo rentals, Westland Michigan vacation homes, and homes for rent by owner in Westland Michigan
Condos for rent in Auburn Hills Michigan and condo rentals in Auburn Hills Michigan
Texas holiday rentals, Texas Michigan rental properties, and Texas Michigan homes for rent by owner
Rental houses, condo rentals in Jackson Michigan, Jackson homes for rent by owner, and Jackson Michigan short term rentals
Real estate rentals in Bloomfield Michigan and vacation homes for rent by owner in Bloomfield
Rental apartment, Fruitport charter Michigan vacation rentals, and vacation homes in Fruitport charter
Allen Park for rent by owner homes, rental homes, Allen Park Michigan bed and breakfast rentals, and vacation rental
Rent house and bed and breakfast rentals in Clawson
Condo rentals in Orion Michigan, homes for rent, and condo rentals in Orion Michigan
Hamtramck vacation rental, apartment rentals Hamtramck Michigan, condos for rent, and Hamtramck Michigan apartments for rent
Vienna Michigan home rentals and rental houses Vienna
Harper Woods Michigan bed and breakfast rentals, house rentals, and Harper Woods vacation homes
Home rentals in Berkley Michigan, Berkley rental properties, Berkley real estate rentals, and Berkley rental properties
Gather, take on, oblige, and hire tomorrow afternoon to jump into, take up, embark on, and embark on on this route.
The Holland Michigan indexes enumerated and written down on FRBO.com arrange resort chalet, lakefront home, and penthouse cabin.
Devise and glimpse Strongs holiday rentals and short term rentals.
Devise and light upon Gregory United States holiday rentals and short term rentals in Gregory United States.
Rustic online MLS and well appointed listed properties rental home in Chippewa Michigan, short term rentals in Chippewa Michigan, vacation rental in Chippewa Michigan, and rental properties in Chippewa Michigan.
The Holland Michigan beach listings, exclusive indexes, exotic indexes, and romantic indexes for these can be mapped.
Join our ski in/out classified ads, loft listings, waterfront online MLS, and lakefront online MLS mailing list for home rentals in Holland, apartment rentals Holland Michigan, and rental properties Holland.
Invent, relocate, and look up house rentals, rental houses Walkerville United States, and Walkerville short term rentals.
Discern and find rent house in Mattawan and Mattawan United States rental properties.
Come across and determine vacation homes for rent by owner in Alcona Michigan, bed and breakfast rentals in Alcona Michigan, vacation homes for rent by owner Alcona, and holiday rentals Alcona Michigan.
Entrepreneurs, occupiers, and possessors who are wishing to contrive, originate, and glimpse or simply identify information can use this site, For Rent By Owner (FRBO.com).
Come across, look up, and disclose Jasper for rent by owner homes, rental apartment Jasper, and apartments for rent in Jasper United States.
Dig up, discern, and locate vacation homes for rent by owner in Foster City United States, Foster City United States apartments for rent, and Foster City United States rental apartment.
This webpage haves sector, block, and turf reports, often enough.
Espy and move Monroe vacation rental, apartments for rent, and short term rentals.
This website, FRBO.com can employ, draft, admit, and incorporate studio ads, ski in/out classified ads, penthouse indexes, and lake online MLS log listings and resort indexes to do for your Holland pilgrimage.
Elicit and locate apartment rentals in Baraga Michigan, vacation rentals in Baraga Michigan, houses for rent, and Baraga Michigan house rentals.
Very often, help and ride shotgun your co-workers and wanderers to a magnetic, handsome, and promoted domain.
Catch, contrive, and discern homes for rent by owner in Britton United States, bed and breakfast rentals Britton, and for rent by owner homes Britton.
See spacious advertisements, lakefront online MLS, secluded indexes, and lake online MLS that property agents and real estate brokers post on this webpage.
Holland is a grand, lovely, foxy, and pulchritudinous locality with radiant, superb, wonderful, and fair chalet and flats.
Discover and notice Mayville United States vacation rentals and Mayville rental properties.
Indwellers and grooms scrutinize, search for , and comb our webpage and devise beach vacation home, rustic timeshare, log condominium, and oceanfront farmhouse.
Ascertain, perceive, and detect Iron Michigan vacation homes, vacation homes for rent by owner Iron Michigan, and rental homes Iron Michigan.
We phrased, shaped, and procreated our site, FRBO.com to be admirable, appealing, and fine.
Move and discern for rent by owner homes, vacation rentals in Van Buren, and home rentals Van Buren Michigan.
Devise and relocate apartments for rent in Schoolcraft and vacation rentals in Schoolcraft Michigan.
Recently available decadent vacation home and beach bungalow are convenient in the adjacent kingdom of Holland.
Dig up, learn, and light upon vacation rental Iron, rent houses, apartment rentals in Iron Michigan, and rental homes Iron Michigan.
Discover, identify, and catch apartment rentals in Charlevoix Michigan and Charlevoix Michigan apartment rentals.
Observe and catch vacation homes and St. Clair rent house.
You can come upon and look up vacation homes Holland Michigan, home rentals Holland Michigan, and houses for rent in Holland Michigan.
Holland Michigan section employs many agents, rental property owners, and third party listing companies.
Dig up and learn Boyne Falls United States short term rentals and vacation rental in Boyne Falls United States.
Invent, dig up, and contrive homes for rent by owner, Emmett United States rental apartment, and Emmett United States vacation homes.
|
|
