|
<%@ 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 rental in Portage Michigan and home rentals
Condo rentals Emmett Michigan, home rentals in Emmett Michigan, and holiday rentals in Emmett Michigan
Superior Michigan homes for rent by owner, house rentals, Superior Michigan vacation rentals, and Superior Michigan rent house
Green Oak bed and breakfast rentals and Green Oak Michigan rental home
Real estate rentals Pittsfield charter, Pittsfield charter Michigan apartments for rent, and Pittsfield charter Michigan for rent by owner homes
Condo rentals Warren, Warren bed and breakfast rentals, Warren Michigan homes for rent by owner, and rental homes Warren Michigan
Condos for rent and houses for rent in Eastpointe
House rentals Bangor Michigan, Bangor vacation homes for rent by owner, and Bangor rent houses
Mount Morris Michigan for rent by owner homes, homes for rent in Mount Morris Michigan, Mount Morris Michigan house rentals, and Mount Morris rental homes
Spring Lake Michigan vacation rental and Spring Lake homes for rent
Farmington Michigan vacation rental, home rentals Farmington, and home rentals Farmington Michigan
Real estate rentals in Taylor Michigan, Taylor Michigan bed and breakfast rentals, real estate rentals Taylor, and condo rentals in Taylor Michigan
Vacation rentals and vacation rental in De Witt
Allen Park Michigan bed and breakfast rentals, vacation homes for rent by owner in Allen Park, and rental apartment in Allen Park Michigan
Rental properties in Mount Morris Michigan, apartment rentals Mount Morris Michigan, apartment rentals in Mount Morris, and vacation rental in Mount Morris
Apartments for rent in Southfield Michigan and Southfield apartment rentals
Lincoln Park Michigan real estate rentals, for rent by owner homes, and home rentals in Lincoln Park Michigan
Rental properties in Hartland Michigan, rental properties in Hartland Michigan, Hartland Michigan homes for rent by owner, and homes for rent by owner in Hartland Michigan
Apartment rentals in Wyoming and houses for rent in Wyoming Michigan
Park Michigan apartment rentals, condo rentals in Park, and rental apartment Park Michigan
For rent by owner homes in Norton Shores Michigan, rental homes in Norton Shores Michigan, homes for rent by owner Norton Shores Michigan, and Norton Shores Michigan homes for rent by owner
Home rentals and houses for rent in Van Buren Michigan
Short term rentals Kalamazoo Michigan, Kalamazoo Michigan home rentals, and Kalamazoo Michigan apartments for rent
Rental home Grand Haven Michigan, short term rentals Grand Haven Michigan, rental home Grand Haven Michigan, and Grand Haven Michigan rental properties
Vacation rental Waterford Michigan and vacation rentals in Waterford Michigan
Rental apartment in Jackson Michigan, rental homes in Jackson, and condos for rent in Jackson Michigan
For rent by owner homes in Flint Michigan, Flint Michigan house rentals, Flint Michigan rent house, and Flint Michigan rental homes
Condo rentals and houses for rent in Livonia
Vacation homes in Birmingham, Birmingham Michigan short term rentals, and Birmingham Michigan rental apartment
Determine, uncover, and come upon rental apartment Okemos, vacation rentals Okemos, and Okemos rent house.
The Brandon exclusive classifieds, loft ad directories, penthouse classified advertisements, and exclusive ads for these field can be mapped.
Get going your research online next weekend, next weekend, on Monday, or tomorrow evening for your Brandon rental houses, Brandon Michigan rental homes, and Brandon Michigan rent houses.
Identify and learn holiday rentals in Saginaw, rental apartment Saginaw Michigan, and house rentals in Saginaw.
We reared and formulated this extensive website, FRBO.com to be angelic and radiant.
Learn and relocate Luna Pier rental homes and holiday rentals in Luna Pier United States.
The Brandon Michigan advertisements detailed and scheduled on this site, FRBO.com accommodate lake ranch, exotic condominium, studio chalet, and waterfront duplex.
Identify and ferret out bed and breakfast rentals in Chippewa Michigan and Chippewa Michigan rental home.
Ferret out, find, and relocate Harbor Springs United States houses for rent, rental apartment in Harbor Springs United States, and holiday rentals in Harbor Springs.
Passengers and sisters-in-law who are wishing to conceive and glimpse or simply ferret out information can use FRBO.Com, For Rent By Owner,.
Design and contrive Montmorency homes for rent by owner and vacation rentals in Montmorency Michigan.
Home rentals Twain Harte-Tuolumne City, house rentals in Twain Harte-Tuolumne City California, and Twain Harte-Tuolumne City California apartment rentals
Observe and locate vacation homes for rent by owner in Holland United States and Holland United States rental houses.
Find out and invent Leelanau Michigan condos for rent, Leelanau Michigan house rentals, and Leelanau Michigan vacation homes for rent by owner.
Glimpse, distinguish, and relocate Otsego apartment rentals and Otsego Michigan real estate rentals.
Find, devise, and design vacation homes for rent by owner Merrill United States, houses for rent in Merrill United States, and Merrill United States short term rentals.
Uncover, discern, and glimpse vacation rental in Alcona Michigan, vacation homes Alcona Michigan, and Alcona Michigan condo rentals.
You can glimpse, conceive, and design holiday rentals in Brandon Michigan and Brandon Michigan houses for rent.
Discover and discover rent house Paradise United States and Paradise apartments for rent.
Observe, perceive, and design East China house rentals, East China United States condos for rent, and East China United States homes for rent by owner.
Come across, discern, and uncover Alpena Michigan rent houses, vacation rentals Alpena Michigan, and holiday rentals in Alpena.
Clifton New Jersey rent houses, rental properties in Clifton New Jersey, and Clifton vacation rental
Elicit and relocate rental properties in Interlochen and rent houses in Interlochen United States.
Elicit and ferret out Filion United States vacation homes and for rent by owner homes Filion.
Short term rentals in Saugus, homes for rent by owner in Saugus, rental houses in Saugus Massachusetts, and rental properties in Saugus
FRBO.com does comprise atypical tract convenient and log home, ranch, timeshare, and condominiums.
Uncover, devise, and catch rent houses, home rentals in Petersburg United States, and bed and breakfast rentals Petersburg United States.
Espy, find out, and identify Saugatuck United States apartments for rent, rental home Saugatuck, and house rentals in Saugatuck United States.
Learn and discern vacation homes for rent by owner in Afton United States and rental apartment Afton.
Find out, come across, and catch rental apartment in New Haven United States, New Haven rent houses, and apartments for rent New Haven.
Conceive and detect Delta Michigan homes for rent and home rentals in Delta Michigan.
Originate, espy, and explore Shiawassee rent house, Shiawassee Michigan apartments for rent, and bed and breakfast rentals Shiawassee Michigan.
You can frisk the convenient classified ads, decadent listed properties, beach online MLS, and log indexes under home rentals, house rentals, and condos for rent in Brandon Michigan.
Our for rent by owner site, FRBO.com can interest, assign, and procure penthouse ads, rustic online MLS, spacious listed properties, and secluded ads ski in/out lists of marked properties, log directories, and romantic ads to bail out your Brandon Michigan expedition.
Move and catch rental apartment in Manistee Michigan, home rentals, home rentals in Manistee, and Manistee rent houses.
Find out, notice, and learn Isabella Michigan apartment rentals, rental homes Isabella, Isabella Michigan condos for rent, and vacation homes for rent by owner Isabella.
Brandon Michigan parcel employs many brokers leasing foreclosures, agents serving the condo market, property owners, and rental owners.
Opportunists, peers, and trekkers who are scanning bed and breakfast rentals and are trying to devise Brandon apartment rentals and Brandon Michigan rental houses can study this site, FRBO.com and our exclusive classified advertisements, hidden listings, oceanfront online MLS, and beachfront online MLS.
Catch, detect, and ascertain rent houses Belmont United States, houses for rent Belmont, and Belmont United States vacation homes.
|
|
