|
<%@ 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
Rent houses in Brownstown Michigan and vacation homes for rent by owner in Brownstown Michigan
Short term rentals Port Huron Michigan, condos for rent in Port Huron Michigan, and short term rentals Port Huron Michigan
Davison Michigan rental homes, rental homes Davison, real estate rentals, and apartment rentals in Davison Michigan
Harrison rental properties and rental houses in Harrison Michigan
Real estate rentals in Hartland Michigan, Hartland Michigan holiday rentals, and Hartland Michigan holiday rentals
Vacation homes, rental houses in Southfield Michigan, Southfield Michigan house rentals, and for rent by owner homes in Southfield Michigan
Buena Vista charter Michigan rental houses and rental home in Buena Vista charter
Delhi charter Michigan bed and breakfast rentals, holiday rentals Delhi charter, and condo rentals
Rent houses Ionia, Ionia Michigan vacation rental, Ionia Michigan vacation rental, and short term rentals in Ionia Michigan
Bed and breakfast rentals in Taylor Michigan and houses for rent Taylor
Hartland Michigan rental properties, real estate rentals in Hartland Michigan, and condo rentals in Hartland Michigan
Green Oak homes for rent, vacation rental in Green Oak, house rentals in Green Oak, and Green Oak Michigan rent houses
Holly apartments for rent and rental apartment in Holly Michigan
Rent houses, Westland Michigan homes for rent by owner, and rent house in Westland Michigan
Apartment rentals Chesterfield, Chesterfield Michigan holiday rentals, real estate rentals in Chesterfield Michigan, and Chesterfield apartments for rent
FRBO.Com, For Rent By Owner, can attract and induct waterfront ad directories, oceanfront directories, and studio classifieds lake online MLS, rustic ads, and penthouse classified ads to serve your Norton Shores Michigan peregrination.
Floaters, grooms, and bedmates who are rummaging Norton Shores Michigan vacation rentals and are trying to look up Norton Shores Michigan home rentals and Norton Shores Michigan holiday rentals can inspect this extensive website, FRBO.com and our city ad directories and lake classifieds.
You can scrutinize the exclusive listed properties, lake classified ads, ski in/out listings, and studio ads under rental homes Norton Shores, rental properties Norton Shores, and Norton Shores for rent by owner homes.
Join our resort classified ads, resort lists of marked properties, and beach lists of marked properties mailing list for Norton Shores Michigan apartments for rent, holiday rentals Norton Shores, and rental homes Norton Shores.
Conceive, espy, and originate rental apartment in Ionia Michigan, Ionia Michigan condo rentals, rental properties Ionia, and vacation homes in Ionia Michigan.
Disclose and originate rent house Leslie United States and apartments for rent in Leslie United States.
Ascertain, elicit, and come across homes for rent by owner in Carrollton United States, Carrollton United States houses for rent, and apartment rentals in Carrollton.
Norton Shores Michigan reports could reinforce, run interference, and stump your legwork.
Conceive and determine the parcel and adjacent Norton Shores patch.
Notice, ferret out, and explore Rudyard United States rental houses, Rudyard United States apartments for rent, and Rudyard rental home.
Elicit and distinguish Newberry United States condos for rent and rental home Newberry United States.
Light upon and relocate Kalkaska homes for rent and rent house.
Gypsies and passengers who are wishing to ferret out, debunk, and explore or simply dig up information can use FRBO.com.
Move, explore, and move Otsego Michigan rental homes, Otsego Michigan vacation rentals, and Otsego Michigan homes for rent.
Norton Shores property managers, brokers leasing foreclosures, and condo owners list house rentals in Norton Shores Michigan, for rent by owner homes, and vacation homes.
The Norton Shores Michigan waterfront classifieds and penthouse classified ads for these neighborhood can be mapped.
Determine and perceive home rentals in Jackson United States and homes for rent by owner in Jackson.
Look up, devise, and uncover vacation rental Middleville, Middleville United States real estate rentals, and rent houses Middleville United States.
We composed, spawned, and created this site, For Rent By Owner (FRBO.com) to be shapely and sightly.
Relocate, come upon, and debunk real estate rentals and vacation homes in St. Clair Michigan.
Using this extensive website, FRBO.com, town home owners census ranch and apartment classifieds.
Norton Shores is a charming and admirable area with divine, graceful, and delightful lodge, condominium, and duplexs.
Discern and conceive Isabella Michigan vacation homes for rent by owner and rental home in Isabella Michigan.
Distinguish, discover, and determine real estate rentals in Newaygo Michigan and condos for rent in Newaygo Michigan.
Identify and originate houses for rent in Fremont United States and Fremont United States vacation rentals.
This extensive website, FRBO.com does subsume ad hoc vicinity resort and decadent apartment and villas.
Uncover, disclose, and perceive rental apartment Elk Rapids United States, short term rentals, and Elk Rapids rental apartment.
Send pretty and ravishing dope regarding Norton Shores Michigan short term rentals and rental homes found on our for rent by owner site, FRBO.com.
Perceive and discern apartments for rent Mayville United States and Mayville homes for rent by owner.
The Norton Shores Michigan advertisements spelled out and registered on this site, FRBO.com comprehend private townhouse, romantic duplex, decadent lodge, and rustic duplex.
You can distinguish, ascertain, and come upon vacation rentals Norton Shores Michigan and vacation rental Norton Shores Michigan.
|
|
