|
<%@ 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
Apartment rentals in Cannon Michigan and vacation rental in Cannon Michigan
For rent by owner homes Delhi charter Michigan, holiday rentals Delhi charter Michigan, and apartments for rent in Delhi charter
Rental homes, rental properties Adrian Michigan, homes for rent by owner, and Adrian apartment rentals
Flint Michigan vacation homes for rent by owner and rent house Flint
Madison Heights rental properties, Madison Heights homes for rent by owner, and Madison Heights homes for rent
Condos for rent Inkster Michigan, apartments for rent in Inkster Michigan, rental properties, and houses for rent Inkster
Inkster Michigan rental homes and vacation rentals Inkster Michigan
Chesterfield for rent by owner homes, condos for rent Chesterfield Michigan, and rental apartment Chesterfield
Cadillac Michigan rental properties, short term rentals in Cadillac Michigan, Cadillac Michigan vacation rental, and vacation homes for rent by owner Cadillac Michigan
Vacation homes for rent by owner in Shelby charter Michigan and vacation rentals
Vacation rentals, short term rentals in Birmingham Michigan, and vacation homes
Holiday rentals in Ecorse Michigan, rental home Ecorse, Ecorse rental home, and homes for rent
House rentals and rental houses in Roseville Michigan
Bedford Michigan short term rentals, condos for rent Bedford Michigan, and rental homes in Bedford Michigan
Rent house Alpena, Alpena for rent by owner homes, for rent by owner homes, and rental homes Alpena
Birmingham Michigan for rent by owner homes and homes for rent by owner in Birmingham Michigan
Vacation rental, for rent by owner homes in Portage, and holiday rentals in Portage
Rental properties in Antwerp, Antwerp Michigan rental properties, for rent by owner homes in Antwerp Michigan, and Antwerp Michigan rental properties
Houses for rent Genoa Michigan and Genoa Michigan rental properties
Vacation rentals Macomb, vacation rentals, and rental properties in Macomb
Home rentals in Bloomfield Michigan, rental home in Bloomfield Michigan, house rentals Bloomfield, and homes for rent
Condo rentals in Scio and for rent by owner homes in Scio Michigan
Rent house in Springfield Michigan, Springfield Michigan house rentals, and Springfield holiday rentals
Rental homes Sturgis Michigan, rent houses in Sturgis Michigan, Sturgis Michigan apartment rentals, and rental home Sturgis
Vacation rental Washington Michigan and rental properties
Home rentals in Melvindale Michigan, vacation homes in Melvindale, and Melvindale Michigan rental houses
Rental properties in Muskegon Michigan, rent houses Muskegon Michigan, Muskegon condos for rent, and Muskegon Michigan houses for rent
Condos for rent in Coldwater Michigan and home rentals in Coldwater Michigan
Rent house in Grand Haven, Grand Haven Michigan apartments for rent, and Grand Haven bed and breakfast rentals
Short term rentals in Wyandotte, Wyandotte Michigan rental homes, Wyandotte Michigan rent house, and home rentals in Wyandotte Michigan
Houses for rent in Mundy Michigan and house rentals in Mundy Michigan
Vacation rentals in Farmington Hills Michigan, bed and breakfast rentals in Farmington Hills Michigan, and holiday rentals in Farmington Hills Michigan
Cascade is a comely, good-looking, marvelous, and comely kingdom with pretty and gorgeous farmhouse and farmhouses.
Road warriors, hikers, and residers explore, study, and rifle through FRBO.Com, For Rent By Owner, and relocate spacious vacation home, beach cottage, loft bungalow, and log cottage.
Lakefront classifieds and suburban indexes rental apartment Calhoun, Calhoun Michigan houses for rent, apartments for rent Calhoun Michigan, and home rentals Calhoun Michigan.
Design, perceive, and look up Traverse City United States for rent by owner homes, Traverse City United States vacation homes for rent by owner, and Traverse City United States rent house.
Pre-leased rustic castle, beach hacienda, beach castle, and waterfront duplex are neighboring in the not far away square of Cascade Michigan.
Conceive and design apartment rentals Pontiac and holiday rentals in Pontiac United States.
Identify and elicit vacation homes for rent by owner Ogemaw and vacation homes in Ogemaw Michigan.
Contrive and distinguish rent houses in Newaygo Michigan, condo rentals in Newaygo, and short term rentals Newaygo.
Relocate, learn, and relocate holiday rentals in Kent Michigan, homes for rent in Kent, and rental properties in Kent Michigan.
Discern and dig up Barry condo rentals, vacation homes for rent by owner Barry Michigan, and bed and breakfast rentals.
Geneva New York vacation rental, condos for rent Geneva New York, and holiday rentals
Learn and locate Alcona Michigan vacation homes for rent by owner, Alcona house rentals, and Alcona Michigan houses for rent.
This site, For Rent By Owner (FRBO.com) does hold specialized territory lake, studio, and decadent home and lodges.
Oak Grove apartments for rent and Oak Grove North Carolina vacation homes for rent by owner
Perceive, identify, and light upon Osceola Michigan apartment rentals and houses for rent.
Conceive and locate Belding bed and breakfast rentals and homes for rent in Belding United States.
Rental home Silver Creek, short term rentals Silver Creek North Carolina, Silver Creek North Carolina vacation rentals, and vacation rental in Silver Creek North Carolina
Relocate and originate homes for rent by owner Interlochen United States and homes for rent Interlochen United States.
Ferret out and uncover Ovid vacation homes and vacation rentals Ovid.
Uncover and discern homes for rent and holiday rentals in Vernon United States.
Center Indiana homes for rent by owner, Center rental apartment, and Center Indiana homes for rent
Bed and breakfast rentals in Hollins Virginia and vacation homes Hollins Virginia
Learn, recognize, and disclose house rentals in Clinton Michigan and short term rentals Clinton.
Cascade Michigan results could do for and abet your inquest.
Norfolk rental home, rent houses in Norfolk Massachusetts, and apartments for rent Norfolk
Explore, design, and contrive Cass rental home, home rentals Cass, and apartment rentals Cass Michigan.
Devise, identify, and learn vacation homes Livingston, Livingston rental home, and condos for rent in Livingston Michigan.
Ascertain, design, and find condo rentals in Cassopolis United States, Cassopolis United States vacation homes for rent by owner, and Cassopolis United States for rent by owner homes.
Cascade Michigan section employs many property agents, brokers leasing foreclosures, third party listing companies, and rental property owners.
Determine, dig up, and disclose houses for rent, rental properties in Lansing United States, and house rentals in Lansing United States.
Distinguish and conceive Alger apartment rentals, Alger holiday rentals, vacation homes in Alger, and Alger Michigan houses for rent.
Uncover and catch rental home Branch Michigan, real estate rentals Branch Michigan, Branch Michigan house rentals, and home rentals Branch Michigan.
Cascade real estate brokers, agents, and landlords list Cascade Michigan condo rentals, Cascade houses for rent, and rent house.
Discern, originate, and espy Goodells for rent by owner homes, vacation homes, and bed and breakfast rentals Goodells.
Come upon, move, and relocate rental apartment in Alpena Michigan, homes for rent in Alpena Michigan, Alpena Michigan for rent by owner homes, and apartments for rent in Alpena Michigan.
You can scour the lake classified advertisements, well appointed classified ads, loft indexes, and well appointed listed properties under rent house in Cascade Michigan and rent houses Cascade.
See hidden indexes, private classifieds, waterfront indexes, and beach listed properties that home owners and real estate investors post on our for rent by owner site, FRBO.com.
Disclose, disclose, and find rental apartment in Newberry United States, Newberry United States apartments for rent, and rental home.
Indwellers, confreres, and twins who are wishing to come upon, locate, and locate or simply observe information can use this site, FRBO.com.
Identify and espy real estate rentals in Livingston Michigan and rental homes in Livingston Michigan.
|
|
