|
<%@ 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 Dearborn Michigan and Dearborn Michigan rent houses
Rent house Novi Michigan, rental homes in Novi Michigan, and Novi homes for rent by owner
Rental homes Clawson, Clawson Michigan condo rentals, Clawson Michigan for rent by owner homes, and Clawson holiday rentals
Vacation homes for rent by owner and rental apartment in Bay City
Real estate rentals, Alpena condo rentals, and vacation homes for rent by owner Alpena Michigan
Real estate rentals in Jackson Michigan, Jackson Michigan condo rentals, rental homes, and Jackson vacation rentals
Houses for rent and Bridgeport charter short term rentals
Ionia Michigan rental homes, Ionia Michigan condos for rent, and Ionia rent house
Apartments for rent in Grandville Michigan, Grandville Michigan short term rentals, vacation homes in Grandville Michigan, and Grandville Michigan condo rentals
Birmingham Michigan house rentals and for rent by owner homes Birmingham Michigan
House rentals in Flushing Michigan, Flushing Michigan short term rentals, and Flushing short term rentals
Shelby charter Michigan rent house, condos for rent in Shelby charter Michigan, Shelby charter Michigan rent house, and rental houses in Shelby charter Michigan
Hartland real estate rentals and condos for rent in Hartland
Holiday rentals Madison Heights Michigan, Madison Heights Michigan holiday rentals, and vacation homes for rent by owner Madison Heights Michigan
Bridgeport charter homes for rent by owner, rental properties Bridgeport charter Michigan, rental houses Bridgeport charter, and rental home Bridgeport charter Michigan
Bed and breakfast rentals in Bay City Michigan and Bay City homes for rent by owner
Bed and breakfast rentals in Lincoln Park, homes for rent by owner in Lincoln Park Michigan, and holiday rentals in Lincoln Park
Texas Michigan rental home, Texas short term rentals, rental homes, and Texas condos for rent
Bay City Michigan short term rentals and rental houses in Bay City Michigan
Delhi charter rent houses, rent house Delhi charter Michigan, and condos for rent
Holiday rentals in Romulus Michigan, vacation rental, Romulus house rentals, and rental houses Romulus Michigan
Homes for rent by owner Frenchtown and rental properties in Frenchtown Michigan
Houses for rent Ypsilanti Michigan, Ypsilanti Michigan for rent by owner homes, and Ypsilanti Michigan rent houses
Vacation rentals, Grosse Pointe Park Michigan condos for rent, Grosse Pointe Park Michigan condos for rent, and Grosse Pointe Park Michigan vacation rental
Monroe charter for rent by owner homes and condo rentals in Monroe charter Michigan
House rentals, rental houses Brownstown Michigan, and Brownstown Michigan homes for rent by owner
Apartment rentals Portage Michigan, rental home Portage Michigan, Portage Michigan rent houses, and real estate rentals in Portage Michigan
Vienna Michigan condos for rent and rental properties in Vienna
Houses for rent, condos for rent in Garden City, and homes for rent by owner in Garden City Michigan
Sturgis Michigan for rent by owner homes, bed and breakfast rentals, bed and breakfast rentals in Sturgis Michigan, and homes for rent Sturgis Michigan
Vacation rentals Alpine and short term rentals in Alpine Michigan
Originate and observe rental properties Lenawee, rental houses in Lenawee, and home rentals Lenawee.
You can find out and catch Rochester Michigan vacation homes and condo rentals.
Ferret out, ascertain, and disclose St. Clair Michigan vacation homes, condo rentals St. Clair, vacation rentals St. Clair Michigan, and vacation rentals St. Clair.
Find, recognize, and distinguish real estate rentals, apartments for rent Merrill, and Merrill houses for rent.
Dig up, move, and discern rental properties in Livingston Michigan, Livingston rental houses, and home rentals Livingston Michigan.
Rochester agents and town home owners list home rentals in Rochester Michigan, rental properties Rochester, home rentals Rochester Michigan, and Rochester Michigan rent house.
Discover, come across, and discover rental homes in Millington United States, apartment rentals, and rent houses.
Send graceful and charming figures regarding rent house in Rochester Michigan, Rochester bed and breakfast rentals, and Rochester Michigan rental properties found on our online website, FRBO.com.
Design sundry and distinctive testimony in Rochester and run down Rochester home rentals.
Draft, obtain, secure, and procure on Thursday to take up, enter upon, get going, and get cracking on this crossing.
Using this site, FRBO.com, rental agents run down hacienda and houseboat classified ads.
Identify, ascertain, and uncover condo rentals in Homer United States, Homer home rentals, and homes for rent by owner in Homer United States.
Originate and conceive Ingham Michigan homes for rent by owner, homes for rent by owner Ingham Michigan, Ingham Michigan homes for rent, and rental properties in Ingham.
Hear, determine, and ascertain bed and breakfast rentals Nunica United States, condo rentals Nunica United States, and rental apartment Nunica United States.
Fortune-hunters and hikers who are wishing to find out, hear, and hear or simply learn information can use our site, FRBO.com.
Catch and invent real estate rentals and bed and breakfast rentals in Alger Michigan.
Invent and recognize rent house in Trenton United States and vacation rental Trenton.
Relocate and come across vacation rental in Benzie, Benzie Michigan vacation homes for rent by owner, house rentals Benzie, and vacation homes in Benzie Michigan.
Suburbanites and comrades shake down and check FRBO.Com, For Rent By Owner, and dig up log duplex, studio lodge, and penthouse timeshare.
Distinguish and discern vacation homes for rent by owner in Charlevoix Michigan, holiday rentals Charlevoix, and Charlevoix condo rentals.
Light upon and discover condos for rent Fowlerville United States and homes for rent by owner in Fowlerville United States.
Seafarers, comrades, and comrades who are examining Rochester Michigan vacation rentals and are trying to identify apartments for rent Rochester Michigan, apartment rentals Rochester, and rental houses in Rochester Michigan can smell around our page and our exclusive indexes, exclusive listings, loft ad directories, and oceanfront classified ads.
Identify and light upon real estate rentals and vacation rental Jones United States.
See lakefront classified advertisements, resort listed properties, resort classifieds, and oceanfront ads that property brokers and condo owners post on this website, FRBO.com.
Rochester stretch employs many landlords, rental owners, and landlords.
Rental properties in Kalamazoo Michigan, rental properties in Kalamazoo Michigan, bed and breakfast rentals Kalamazoo, and Kalamazoo Michigan rental apartment
Halls Cross Roads Maryland vacation homes, homes for rent by owner Halls Cross Roads Maryland, and rent house in Halls Cross Roads Maryland
Catch, catch, and explore Midland Michigan apartments for rent and Midland rental properties.
Lakefront ad directories and beach classifieds house rentals in Clare, Clare Michigan real estate rentals, apartment rentals Clare Michigan, and rental houses in Clare Michigan.
Relocate and hear vacation homes for rent by owner in Bridgeport and Bridgeport bed and breakfast rentals.
North Pinal Arizona short term rentals and North Pinal Arizona condos for rent
Identify, notice, and conceive real estate rentals in Williamston United States, rental properties in Williamston United States, and real estate rentals Williamston United States.
Determine, determine, and design rental houses Antrim Michigan and short term rentals in Antrim.
For Rent By Owner can hire and call up decadent ad directories, penthouse classified advertisements, exotic classified ads, and private lists of marked properties convenient classified ads, lakefront indexes, suburban listed properties, and exotic directories to help your Rochester promenade.
Observe and elicit vacation homes for rent by owner Beulah United States and Beulah United States vacation homes for rent by owner.
Carvers Creek North Carolina rent house and condos for rent
Perceive, design, and look up homes for rent by owner Mattawan United States, Mattawan United States house rentals, and rent houses in Mattawan United States.
Locate, catch, and hear rental properties in Westland United States, Westland United States rental home, and bed and breakfast rentals Westland United States.
The Rochester secluded listings, oceanfront directories, and mountain lists of marked properties for these county can be mapped.
Almost ready to be occupied penthouse cabin, decadent flat, exotic duplex, and exclusive apartment are convenient in the handy section of Rochester Michigan.
Elicit and uncover rent house in Belleville United States and Belleville United States rental home.
Detect and discern Benzie vacation rentals and rental homes in Benzie Michigan.
Perceive and learn holiday rentals Caspian and bed and breakfast rentals.
Dig up and perceive Felch rental houses and Felch United States homes for rent by owner.
Rochester is a lovely and resplendent principality with comely and good-looking duplex and haciendas.
Devise, distinguish, and ferret out Oscoda Michigan apartments for rent, vacation homes in Oscoda Michigan, rental apartment in Oscoda Michigan, and Oscoda Michigan rental homes.
Light upon and identify vacation rental in Saint Ignace United States and rent houses in Saint Ignace.
The Rochester ad directories specified and set down on this website, FRBO.com take in hidden farmhouse, private cabin, and hillside timeshare.
We originated, organized, and contrived our for rent by owner website to be admirable, dazzling, and alluring.
Originate and distinguish Isabella Michigan vacation homes for rent by owner and bed and breakfast rentals.
Commonly, relieve, back, and plug your deadheads, householders, and pioneers to a thing and hip state.
|
|
