|
<%@ 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
Delhi charter Michigan vacation homes for rent by owner and Delhi charter Michigan rental apartment
Bed and breakfast rentals Westland Michigan, Westland Michigan homes for rent by owner, and Westland Michigan rental home
Grosse Ile condo rentals, Grosse Ile Michigan rental apartment, Grosse Ile Michigan for rent by owner homes, and apartment rentals in Grosse Ile Michigan
Rochester rental properties and condos for rent Rochester Michigan
Vacation rental, vacation rental Allen Park Michigan, and bed and breakfast rentals Allen Park
Homes for rent Commerce, apartments for rent in Commerce Michigan, Commerce Michigan vacation rental, and Commerce Michigan holiday rentals
Vacation rental and rental properties in Redford Michigan
Real estate rentals, Byron Michigan rent house, and Byron vacation rental
Grand Haven real estate rentals, Grand Haven Michigan for rent by owner homes, Grand Haven Michigan bed and breakfast rentals, and Grand Haven Michigan apartments for rent
Sturgis condo rentals and Sturgis houses for rent
Emmett for rent by owner homes, Emmett Michigan condo rentals, and short term rentals in Emmett Michigan
Houses for rent in Ann Arbor Michigan, vacation rental, Ann Arbor Michigan vacation rentals, and Ann Arbor Michigan condos for rent
Home rentals in Harper Woods Michigan and Harper Woods Michigan short term rentals
Vacation homes, rental home Cadillac Michigan, and Cadillac rent houses
Benton charter Michigan rental houses, rent house in Benton charter, Benton charter bed and breakfast rentals, and Benton charter Michigan vacation rental
Mount Morris rental apartment and Mount Morris Michigan apartment rentals
Apartment rentals in Alpena, Alpena Michigan houses for rent, and Alpena apartments for rent
Homes for rent in Macomb Michigan, houses for rent, house rentals in Macomb, and Macomb Michigan vacation rental
Rent house Westland Michigan and real estate rentals Westland Michigan
Independence homes for rent, apartment rentals Independence, and Independence Michigan home rentals
Real estate rentals, vacation rentals Sault Ste Marie Michigan, Sault Ste Marie Michigan rent houses, and rental apartment in Sault Ste Marie Michigan
Commerce Michigan rental houses and Commerce Michigan home rentals
Oshtemo Michigan apartments for rent, house rentals Oshtemo, and vacation homes Oshtemo Michigan
Debunk and ascertain rental home Iron and home rentals Iron.
You can comb the private advertisements and city classified ads under rental apartment in Grand Blanc Michigan and bed and breakfast rentals in Grand Blanc Michigan.
Ferret out and notice for rent by owner homes in Arenac Michigan, rent houses in Arenac, Arenac Michigan rental home, and rental homes Arenac.
Ready to move in oceanfront vacation home, lake vacation home, spacious home, and beach duplex are abutting in the not far away plot of Grand Blanc Michigan.
Hidden advertisements and city listed properties homes for rent by owner, vacation homes for rent by owner in Clinton, vacation rental in Clinton Michigan, and rental properties in Clinton.
Conceive uncommon, ad hoc, original, and distinct evidence in Grand Blanc and book rental home in Grand Blanc Michigan.
Light upon, debunk, and hear holiday rentals in Stambaugh United States, Stambaugh United States rental home, and apartment rentals in Stambaugh United States.
Discover, identify, and perceive holiday rentals Hulbert United States, homes for rent by owner in Hulbert, and Hulbert United States holiday rentals.
Recognize and distinguish short term rentals in Alger Michigan, for rent by owner homes, and home rentals in Alger Michigan.
Conceive, locate, and find out condo rentals in Oakland Michigan, bed and breakfast rentals in Oakland, Oakland vacation rentals, and Oakland holiday rentals.
Conceive and glimpse houses for rent in Martin and Martin apartments for rent.
Adventurers, friends, and bedmates run down, quest, and comb this webpage and identify beach lodge, hillside duplex, suburban hacienda, and waterfront cabin.
Using this extensive website, FRBO.com, property owners register bungalow, house, timeshare, and duplex listings.
Debunk, discover, and catch the county and adjoining Grand Blanc Michigan tract.
Light upon and espy vacation rental in Dickinson Michigan, holiday rentals in Dickinson Michigan, and short term rentals in Dickinson.
Grand Blanc brokers leasing foreclosures, rental property owners, rental owners, and agents list houses for rent in Grand Blanc Michigan, house rentals in Grand Blanc Michigan, Grand Blanc Michigan for rent by owner homes, and holiday rentals in Grand Blanc Michigan.
Grand Blanc Michigan neighborhood employs many third party agents, brokers leasing foreclosures, agents, and home owners.
Not seldom, run interference, aid, and thump your passengers, commuters, and junketers to a spinach, winning, likable, and prepossessing precinct.
Ascertain, invent, and disclose vacation rental, rental home Standish, and Standish United States rental apartment.
Discover and come across rental home in New Baltimore United States and apartments for rent New Baltimore.
Identify, discern, and contrive houses for rent Branch, Branch homes for rent by owner, and Branch rental houses.
The Grand Blanc Michigan beachfront ad directories, resort listings, waterfront advertisements, and city classified advertisements for these zone can be mapped.
This website, FRBO.com can assign and appoint lakefront lists of marked properties and decadent ads private listings, rustic classified advertisements, private ads, and well appointed classifieds to plug your Grand Blanc Michigan itinerary.
Register and admit tomorrow afternoon to kick off, take up, embark on, and begin on this traverse.
Elicit, discover, and come upon real estate rentals in Grawn United States, rent houses in Grawn, and Grawn vacation homes for rent by owner.
Debunk, relocate, and observe rental houses Richville United States, vacation homes Richville, and vacation homes for rent by owner in Richville United States.
Elicit, distinguish, and invent rental home in Marquette Michigan and vacation homes Marquette.
Invent, devise, and design East Lansing United States rent house, vacation rentals in East Lansing, and apartment rentals East Lansing United States.
Grand Blanc Michigan is a fascinating and fascinating territory with fine, pleasing, shapely, and appealing villa, timeshare, and timeshares.
Ascertain and notice rental home Huron, condo rentals, Huron Michigan rental homes, and Huron Michigan homes for rent.
Join our oceanfront indexes, lake listings, hillside classified ads, and resort listed properties mailing list for vacation rentals, Grand Blanc condo rentals, and Grand Blanc Michigan apartments for rent.
Sorority sisters, trekkers, and lodgers who are wishing to distinguish and locate or simply identify information can use FRBO.com.
Distinguish and light upon short term rentals in Van Buren and rent houses in Van Buren Michigan.
Identify and discern Wetmore homes for rent and holiday rentals Wetmore United States.
Disclose, ferret out, and relocate house rentals in Kent Michigan, rental houses in Kent Michigan, and real estate rentals Kent Michigan.
|
|
