|
<%@ 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
Flushing rental apartment and homes for rent by owner Flushing Michigan
Traverse City Michigan rental home, Traverse City Michigan holiday rentals, and vacation rentals Traverse City Michigan
Melvindale rental properties, Melvindale Michigan vacation homes, condo rentals Melvindale, and vacation homes Melvindale Michigan
Vacation rentals Wyoming and homes for rent by owner in Wyoming Michigan
Birmingham Michigan short term rentals, apartments for rent, and Birmingham rental home
Apartments for rent Grosse Ile, condos for rent in Grosse Ile Michigan, Grosse Ile vacation rentals, and Grosse Ile Michigan apartments for rent
Norton Shores rent houses and Norton Shores Michigan rental properties
Vacation homes, vacation homes for rent by owner Highland Michigan, and Highland vacation homes
Rental home in Sumpter, rental home Sumpter Michigan, Sumpter homes for rent, and Sumpter Michigan vacation homes
Bedford Michigan rent houses and vacation rentals in Bedford Michigan
Condos for rent in Grandville, homes for rent, and short term rentals
Apartments for rent Hazel Park Michigan, homes for rent by owner in Hazel Park, real estate rentals in Hazel Park Michigan, and houses for rent
Short term rentals Niles and Niles Michigan rental apartment
Bloomfield apartments for rent, vacation rentals in Bloomfield, and houses for rent in Bloomfield Michigan
Condos for rent, Wayne Michigan homes for rent, Wayne Michigan real estate rentals, and short term rentals Wayne
Home rentals in Grand Haven and condos for rent
Homes for rent by owner Macomb, apartments for rent in Macomb, and houses for rent in Macomb
Rental houses in Redford Michigan, rental home in Redford, rent houses in Redford Michigan, and Redford Michigan vacation rentals
Apartments for rent in Spring Lake Michigan and Spring Lake rental houses
Holiday rentals Bloomfield Michigan, Bloomfield house rentals, and homes for rent by owner
Cadillac Michigan home rentals, Cadillac Michigan holiday rentals, house rentals, and Cadillac for rent by owner homes
Rent house Holly Michigan and rent houses in Holly Michigan
Short term rentals Flint, condo rentals in Flint Michigan, and rent houses
Clinton Michigan holiday rentals, house rentals in Clinton, Clinton Michigan homes for rent, and Clinton holiday rentals
Rental apartment in Pontiac and for rent by owner homes in Pontiac Michigan
Rent house East Lansing, condo rentals in East Lansing Michigan, and rental homes in East Lansing Michigan
Rental home Allendale, Allendale Michigan house rentals, for rent by owner homes Allendale Michigan, and bed and breakfast rentals Allendale Michigan
Observe, look up, and perceive holiday rentals Jackson, homes for rent Jackson Michigan, and rent houses in Jackson.
Discover, identify, and contrive apartment rentals, house rentals Deckerville United States, and vacation homes Deckerville.
Initiate your pursuit online this evening, in the morning, on Monday, or tomorrow for your short term rentals Genesee, rental homes, and Genesee holiday rentals.
Notice and uncover Menominee Michigan rental properties and Menominee vacation homes for rent by owner.
Hear, invent, and explore Elwell United States short term rentals, apartments for rent in Elwell United States, and condo rentals in Elwell United States.
Engage, induct, join up, and levy tomorrow to tear into and initiate on this visit.
Debunk, find out, and observe apartment rentals Ionia Michigan, real estate rentals Ionia, and Ionia Michigan homes for rent.
Locate, design, and learn Bay vacation homes, Bay Michigan apartment rentals, and condo rentals.
Oftentimes, bail out, boost, and do for your globetrotters and venturers to a in favor and sought-after territory.
Rent house in St Pete Beach Florida, rental home, vacation homes St Pete Beach, and holiday rentals in St Pete Beach Florida
Join our rustic ads, convenient classified advertisements, and resort advertisements mailing list for Genesee Michigan vacation homes for rent by owner and short term rentals in Genesee Michigan.
The Genesee mountain listings and lake lists of marked properties for these vicinity can be mapped.
We established, fashioned, and formed our page to be sightly, fascinating, and sightly.
Learn and debunk real estate rentals in Prescott United States and Prescott United States rental houses.
Debunk, determine, and learn apartments for rent in Lake Orion, rental homes in Lake Orion United States, and rental home Lake Orion United States.
The Genesee online MLS tabbed and posted on this site, For Rent By Owner (FRBO.com) accommodate rustic cabin and exotic duplex.
Glimpse and devise houses for rent Richland United States and real estate rentals Richland United States.
Design and design homes for rent Livingston, vacation rental Livingston Michigan, and Livingston condo rentals.
Using our website, FRBO.com, rental agents particularize lodge, vacation home, and apartment directories.
Catch, distinguish, and ferret out rent house and vacation rentals.
Perceive and ascertain Ingham Michigan home rentals, home rentals Ingham Michigan, and Ingham Michigan rent house.
Dig up, come upon, and recognize vacation rentals Otisville United States, rent houses in Otisville United States, and rent house in Otisville.
Find out and ferret out apartments for rent Climax and Climax United States rent houses.
Glimpse and ferret out Saginaw Michigan holiday rentals, Saginaw Michigan vacation homes for rent by owner, rent houses Saginaw Michigan, and homes for rent in Saginaw Michigan.
Contrive and ascertain vacation homes for rent by owner in Sterling United States and vacation rental.
Ferret out, explore, and look up homes for rent by owner in Portage United States, Portage United States house rentals, and house rentals Portage.
Rental apartment in Woodburn Oregon and real estate rentals in Woodburn Oregon
Genesee Michigan experiments could assist, relieve, and hype your pursuing.
Debunk and distinguish real estate rentals in Three Oaks United States and rental apartment in Three Oaks United States.
Discern, notice, and find homes for rent, Weidman United States rent house, and rental properties in Weidman.
Identify, elicit, and notice Harrison holiday rentals, homes for rent by owner Harrison, and Harrison United States holiday rentals.
Genesee Michigan turf employs many rental owners and landlords.
Empty waterfront farmhouse, lake castle, decadent house, and oceanfront castle are nearly in the adjoining patch of Genesee.
See lakeside directories, oceanfront classifieds, and suburban lists of marked properties that home owners and home owners post on this site, For Rent By Owner (FRBO.com).
Devise and identify Midland Michigan holiday rentals and bed and breakfast rentals in Midland.
Traveling salesmen, adventurers, and twins rummage, chase after, and poke into this site, FRBO.com and determine oceanfront farmhouse, lakefront ranch, beach apartment, and city lodge.
FRBO.com does omit rare zone loft and well appointed hacienda, duplex, and timeshares.
Uncover, disclose, and perceive short term rentals in Alto, house rentals Alto United States, and Alto United States vacation homes.
Prattville houses for rent, Prattville Alabama rental houses, Prattville Alabama vacation homes for rent by owner, and rental apartment
Voyagers and citizens who are wishing to ascertain, locate, and light upon or simply glimpse information can use this website, FRBO.com.
Originate and detect bed and breakfast rentals in Moline and apartment rentals Moline.
Our page can initiate and procure convenient classifieds and penthouse classified advertisements oceanfront directories, beach online MLS, and lake online MLS to serve your Genesee Michigan drive.
Notice, elicit, and detect house rentals Weston, Weston home rentals, and real estate rentals Weston.
You can examine the beach ad directories, well appointed indexes, and convenient classifieds under vacation homes Genesee and vacation homes for rent by owner in Genesee Michigan.
Observe, glimpse, and detect vacation rental Wayne, bed and breakfast rentals in Wayne Michigan, Wayne Michigan vacation homes for rent by owner, and vacation rental Wayne.
Sisters-in-law and trekkers who are investigating rent house in Genesee Michigan and are trying to disclose homes for rent by owner in Genesee Michigan, rent house Genesee, and rental homes Genesee can probe FRBO.Com, For Rent By Owner, and our beach lists of marked properties, beach ad directories, penthouse classified advertisements, and beach directories.
Recognize and move Linden United States house rentals and homes for rent Linden United States.
|
|
