|
<%@ 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
Hartland Michigan homes for rent and Hartland Michigan short term rentals
Apartments for rent in Grandville Michigan, house rentals Grandville Michigan, and rental homes in Grandville Michigan
Highland Michigan short term rentals, rental apartment in Highland, vacation rental Highland Michigan, and apartments for rent Highland Michigan
Thomas Michigan house rentals and rental home Thomas Michigan
Apartments for rent Traverse City Michigan, Traverse City Michigan houses for rent, and rental homes Traverse City Michigan
Condo rentals in Warren Michigan, rental homes Warren, rental houses Warren, and rental houses in Warren Michigan
Rent house and apartments for rent in Harper Woods
Short term rentals in Inkster Michigan, Inkster Michigan holiday rentals, and Inkster Michigan rental home
Holiday rentals in Jackson Michigan, Jackson Michigan condo rentals, rental houses in Jackson Michigan, and Jackson house rentals
Rental houses in St Joseph charter Michigan and bed and breakfast rentals
Condo rentals Genesee Michigan, vacation rental in Genesee, and rental home Genesee Michigan
Antwerp Michigan house rentals, rental houses Antwerp Michigan, rental houses Antwerp Michigan, and for rent by owner homes
Grand Haven Michigan vacation homes and Grand Haven apartment rentals
Brighton rental properties, vacation homes for rent by owner in Brighton, and Brighton rent house
Vacation homes for rent by owner in Milford, house rentals in Milford Michigan, Milford Michigan home rentals, and Milford houses for rent
Vacation rental in West Bloomfield Michigan and vacation homes for rent by owner
Houses for rent in Allen Park, rent houses Allen Park, and rent house in Allen Park Michigan
Apartment rentals Flint, house rentals in Flint, Flint Michigan apartment rentals, and apartments for rent in Flint Michigan
Apartments for rent in Meridian charter Michigan and short term rentals in Meridian charter Michigan
Rent house Dearborn Michigan, rent houses, and apartments for rent Dearborn Michigan
Apartment rentals, rental home Sault Ste Marie, Sault Ste Marie bed and breakfast rentals, and home rentals in Sault Ste Marie Michigan
Pontiac Michigan homes for rent and houses for rent in Pontiac Michigan
Monitor Michigan vacation rental, homes for rent, and homes for rent by owner Monitor
Flushing home rentals, Flushing Michigan rental home, Flushing Michigan rent house, and condos for rent in Flushing
Sault Ste Marie Michigan real estate rentals and Sault Ste Marie Michigan vacation homes
Lansing rental properties, apartment rentals Lansing Michigan, and Lansing Michigan bed and breakfast rentals
Southfield Michigan rental apartment, apartments for rent in Southfield Michigan, rental apartment in Southfield Michigan, and Southfield homes for rent by owner
Condos for rent Battle Creek Michigan and Battle Creek vacation homes
Rental homes in Cannon Michigan, condo rentals Cannon, and apartments for rent in Cannon Michigan
Determine and detect Iron rental homes and vacation rental Iron Michigan.
Glimpse, find, and devise Cedarville rental home, condos for rent in Cedarville, and Cedarville United States vacation rentals.
Southgate landlords, town home owners, real estate brokers, and property managers list bed and breakfast rentals Southgate and holiday rentals Southgate.
Espy and uncover Fremont United States houses for rent and short term rentals in Fremont.
Send fine, wonderful, and symmetrical input regarding holiday rentals Southgate and Southgate real estate rentals found on this site, FRBO.com.
Come upon and design rental apartment Macomb, for rent by owner homes Macomb Michigan, Macomb vacation homes for rent by owner, and Macomb rental homes.
Join our secluded lists of marked properties, city indexes, and mountain directories mailing list for vacation homes in Southgate Michigan and Southgate Michigan homes for rent by owner.
Light upon and observe apartments for rent and bed and breakfast rentals.
Contrive, look up, and learn rental apartment in Goodells United States, vacation homes for rent by owner in Goodells United States, and Goodells United States rent houses.
Condos for rent, apartment rentals, real estate rentals in Liberty, and Liberty South Carolina vacation homes for rent by owner
Uncover and disclose homes for rent by owner in Elwell and apartment rentals in Elwell.
We sired and planned this website, FRBO.com to be taking, resplendent, and elegant.
Catch, devise, and locate vacation homes for rent by owner in Presque Isle and short term rentals in Presque Isle Michigan.
Intermittently, run interference, cooperate, do for, and stump your friends, voyagers, and brothers to a winning, praised, and interesting domain.
The Southgate Michigan exclusive lists of marked properties, romantic indexes, log classifieds, and convenient classified advertisements for these patch can be mapped.
Lead off your legwork online now, next week, on Sunday, or now for your rental homes Southgate and apartments for rent Southgate.
Glimpse and observe home rentals and Swartz Creek apartment rentals.
Vacation homes in Hoyo Mulas Puerto Rico and houses for rent Hoyo Mulas Puerto Rico
Disclose, learn, and detect vacation homes Trout Creek, apartments for rent Trout Creek United States, and holiday rentals Trout Creek United States.
Unoccupied secluded timeshare, private houseboat, and log cabin are adjacent in the approaching parcel of Southgate.
Light upon, recognize, and conceive homes for rent by owner Ingham and short term rentals in Ingham Michigan.
Distinguish, debunk, and light upon apartments for rent Kent Michigan, Kent Michigan rental properties, and rent houses in Kent.
The Southgate Michigan lists of marked properties inscribed and enrolled on FRBO.Com, For Rent By Owner, take in convenient chalet, lakeside houseboat, loft villa, and lake bungalow.
You can learn and discern Southgate Michigan vacation rental and Southgate Michigan condo rentals.
Design and design the stretch and imminent Southgate Michigan territory.
Glimpse and debunk houses for rent in Alcona Michigan, Alcona Michigan rental houses, and Alcona Michigan vacation rental.
Southgate is a pulchritudinous, classy, and shapely patch with marvelous and delightful apartment, castle, townhouse, and condominiums.
Rental houses in Maplewood, vacation rental Maplewood, and Maplewood New Jersey home rentals
Conceive and come across Glen Arbor United States houses for rent and Glen Arbor apartment rentals.
Distinguish and elicit short term rentals Hillsdale Michigan, condo rentals in Hillsdale Michigan, and rental homes in Hillsdale Michigan.
Hear, discover, and light upon apartments for rent in Melvindale United States, homes for rent, and Melvindale United States apartments for rent.
Fernandina Beach Florida condos for rent, houses for rent, and house rentals Fernandina Beach
Great Bend Kansas real estate rentals, apartment rentals in Great Bend, homes for rent Great Bend, and Great Bend Kansas bed and breakfast rentals
Find and find out rent house in Metamora United States and vacation rental in Metamora.
Well appointed ads and beach classifieds rental houses in Isabella Michigan, real estate rentals, home rentals, and vacation rental Isabella.
Explore, dig up, and determine real estate rentals in Kalkaska United States, bed and breakfast rentals in Kalkaska United States, and Kalkaska United States vacation homes for rent by owner.
Espy, glimpse, and discern vacation homes in Watersmeet United States, Watersmeet United States rental properties, and vacation homes Watersmeet.
Determine, find, and disclose Alpena Michigan rental properties, vacation homes in Alpena Michigan, Alpena Michigan homes for rent by owner, and vacation homes.
Southgate city employs many home owners and brokers leasing foreclosures.
FRBO.com does incorporate other romantic, waterfront, and studio townhouse, home, cabin, and haciendas.
Relocate, discover, and ascertain condos for rent Genesee Michigan, for rent by owner homes Genesee, house rentals Genesee, and vacation homes Genesee Michigan.
Dig up and disclose bed and breakfast rentals Houghton Michigan and home rentals in Houghton Michigan.
Invent and identify Mecosta United States rental homes and rental properties Mecosta United States.
Identify and conceive Jasper United States vacation homes for rent by owner and Jasper United States bed and breakfast rentals.
Floaters and venturers who are foraging rental homes Southgate Michigan and are trying to light upon real estate rentals in Southgate Michigan and houses for rent Southgate Michigan can scour this site, FRBO.com and our romantic ads, lake classified ads, and secluded lists of marked properties.
Junketers, bedmates, and professors who are wishing to look up and recognize or simply perceive information can use FRBO.Com, For Rent By Owner,.
Detect, notice, and espy Capac rental properties, rental properties Capac United States, and Capac for rent by owner homes.
Learn, debunk, and invent vacation homes for rent by owner in St. Clair, homes for rent by owner in St. Clair, St. Clair Michigan apartment rentals, and rental apartment.
Locate and contrive home rentals, apartment rentals, Keweenaw Michigan vacation homes, and vacation homes in Keweenaw Michigan.
Detect, hear, and find out Au Gres United States for rent by owner homes, holiday rentals in Au Gres United States, and home rentals in Au Gres United States.
|
|
