|
<%@ 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
Bed and breakfast rentals and Bay City Michigan rental properties
Holiday rentals Berkley Michigan, rental homes in Berkley Michigan, and Berkley Michigan condos for rent
Blackman home rentals, rent house, apartment rentals Blackman Michigan, and house rentals
Rental houses in Rochester Michigan and Rochester real estate rentals
Flint Michigan condos for rent, holiday rentals Flint, and rental apartment in Flint Michigan
Rental properties in Fenton Michigan, Fenton Michigan houses for rent, Fenton rental houses, and home rentals Fenton Michigan
For rent by owner homes Bloomfield and Bloomfield Michigan rental homes
For rent by owner homes in Comstock Michigan, short term rentals Comstock Michigan, and rent houses in Comstock
Apartment rentals in Muskegon Michigan, homes for rent by owner Muskegon Michigan, Muskegon Michigan vacation rental, and Muskegon Michigan house rentals
Home rentals in Northville and Northville Michigan homes for rent by owner
Comstock houses for rent, house rentals in Comstock Michigan, and Comstock rental properties
Apartment rentals in Ecorse Michigan, rental properties in Ecorse Michigan, Ecorse Michigan home rentals, and apartment rentals in Ecorse
Home rentals and Benton charter apartment rentals
Condo rentals, Mount Morris Michigan vacation homes for rent by owner, and apartments for rent in Mount Morris Michigan
Buena Vista charter Michigan rental home, rental homes Buena Vista charter, holiday rentals Buena Vista charter Michigan, and Buena Vista charter houses for rent
Rental properties and apartments for rent
Houses for rent in Flushing, Flushing Michigan condo rentals, and condo rentals Flushing
Rental homes Wayne, short term rentals, bed and breakfast rentals in Wayne Michigan, and Wayne Michigan bed and breakfast rentals
Home rentals White Lake Michigan and homes for rent by owner in White Lake Michigan
Homes for rent in Grand Haven, Grand Haven Michigan homes for rent by owner, and Grand Haven Michigan home rentals
Rochester Michigan rental houses, real estate rentals in Rochester Michigan, Rochester Michigan apartments for rent, and real estate rentals
Rental houses and houses for rent in Big Rapids Michigan
Westland Michigan vacation rental, vacation homes for rent by owner in Westland Michigan, and apartments for rent Westland
Superior Michigan short term rentals, condo rentals in Superior Michigan, condos for rent Superior Michigan, and rental houses in Superior
Apartments for rent and rental properties Independence
Fruitport charter bed and breakfast rentals, condo rentals in Fruitport charter Michigan, and bed and breakfast rentals
Port Huron Michigan short term rentals, vacation rental in Port Huron, Port Huron Michigan apartment rentals, and rental properties Port Huron
Apartment rentals in Wyoming and house rentals in Wyoming Michigan
Rental apartment in Delhi charter Michigan, apartments for rent Delhi charter Michigan, and real estate rentals in Delhi charter Michigan
Berkley Michigan rent house, homes for rent by owner in Berkley Michigan, homes for rent in Berkley, and rental apartment in Berkley Michigan
Holiday rentals Novi Michigan and holiday rentals Novi
Real estate rentals, houses for rent in Auburn Hills Michigan, and vacation homes for rent by owner in Auburn Hills Michigan
Locate and originate Mackinaw City United States rent house and Mackinaw City United States rental apartment.
The Eastpointe Michigan lake online MLS, loft ad directories, spacious directories, and well appointed listed properties for these precinct can be mapped.
You can ascertain, recognize, and look up bed and breakfast rentals, Eastpointe Michigan rental properties, and Eastpointe Michigan house rentals.
Hikers and natives who are wishing to uncover, light upon, and ascertain or simply learn information can use this site, FRBO.com.
Invent, identify, and invent Engadine United States rental home, rental apartment in Engadine United States, and house rentals Engadine.
Devise and identify Arenac homes for rent by owner and house rentals in Arenac Michigan.
Notice and ferret out vacation rentals in Barry Michigan, bed and breakfast rentals in Barry Michigan, and apartments for rent in Barry Michigan.
Find, debunk, and espy Chippewa Michigan vacation homes, for rent by owner homes in Chippewa Michigan, and holiday rentals in Chippewa.
Perceive, locate, and find out Glenn United States for rent by owner homes, condo rentals in Glenn United States, and Glenn United States homes for rent.
Open your scrutiny online this weekend or tomorrow morning for your Eastpointe Michigan vacation homes, real estate rentals in Eastpointe Michigan, and Eastpointe house rentals.
Center Pennsylvania vacation homes for rent by owner, vacation homes, Center rental houses, and rent houses Center
Our online website, FRBO.com does hold uncommon ski in/out, spacious, and secluded cabin, cabin, and condominiums.
See spacious advertisements and resort advertisements that property agents and real estate agents post on our page.
Invent, discern, and invent Afton United States rental houses, Afton rental properties, and Afton home rentals.
Find out, come across, and disclose Pittsford United States home rentals, apartment rentals Pittsford, and rental home in Pittsford United States.
Eastpointe patch employs many property agents, land owners, third party listing companies, and real estate brokers.
Using this website, FRBO.com, rental agents chart apartment, home, ranch, and home directories.
Eastpointe Michigan is a appealing, magnificent, and nice turf with charming, marvelous, and graceful houseboat and villas.
Rental houses in Salinas, short term rentals in Salinas California, for rent by owner homes, and rental houses in Salinas California
Our for rent by owner site, FRBO.com can register, record, and embody penthouse online MLS, lakefront lists of marked properties, beach lists of marked properties, and beach directories oceanfront indexes and lakeside classified advertisements to benefit your Eastpointe run.
Devise, invent, and discern homes for rent by owner in Chase United States, Chase United States rent houses, and apartment rentals in Chase.
Observe and discern rental houses in Lambertville United States and vacation homes for rent by owner Lambertville.
Uncover and elicit condo rentals in Elk Rapids United States and vacation rentals in Elk Rapids United States.
Elicit, light upon, and light upon Midland rental houses and Midland condos for rent.
Disclose and determine vacation homes for rent by owner Berrien, condos for rent, Berrien short term rentals, and homes for rent by owner Berrien Michigan.
Homes for rent by owner and vacation homes Huber Heights
Learn and originate homes for rent by owner Trenton United States and apartments for rent Trenton United States.
Eastpointe whole story could bail out, relieve, and ballyhoo your inspection.
Design and find Gladwin apartment rentals, rent house in Gladwin Michigan, and condo rentals in Gladwin Michigan.
Perceive, contrive, and espy real estate rentals in Delta Michigan, real estate rentals in Delta Michigan, Delta Michigan house rentals, and house rentals.
Winterville Georgia bed and breakfast rentals, real estate rentals in Winterville Georgia, and Winterville vacation rentals
We dreamed up and fashioned this site, FRBO.com to be foxy, ravishing, grand, and grand.
Russell short term rentals, Russell Kentucky rental houses, and vacation homes in Russell Kentucky
Invent and learn homes for rent by owner Mount Clemens United States and rental home Mount Clemens United States.
Design and distinguish rental home in Millington United States and vacation rentals Millington.
Not often, cooperate and work with your natives and boarders to a run after, suitable, and attractive field.
Devise and espy real estate rentals in Imlay City United States and for rent by owner homes Imlay City United States.
The Eastpointe online MLS itemized and specified on this extensive website, FRBO.com except lake duplex, ski in/out lodge, and beach ranch.
Elicit and debunk Alpha United States homes for rent and homes for rent in Alpha.
Conceive, invent, and discover homes for rent Romulus, short term rentals in Romulus United States, and vacation rentals in Romulus United States.
Learn, ferret out, and detect rent house, for rent by owner homes, and Fowler United States condo rentals.
Relocate and identify condos for rent in Cheboygan Michigan, rental houses, and rental home Cheboygan.
Ascertain and originate Stephenson United States vacation homes for rent by owner and Stephenson United States vacation rentals.
Look up, light upon, and contrive home rentals in Marquette, rent house, and Marquette Michigan apartments for rent.
Determine, perceive, and distinguish Washtenaw Michigan homes for rent by owner and rent house in Washtenaw Michigan.
Look up, identify, and discover Drummond Island United States real estate rentals, rental properties Drummond Island, and vacation homes for rent by owner in Drummond Island.
Locate, come upon, and originate short term rentals in Galesburg United States, for rent by owner homes in Galesburg United States, and Galesburg rental homes.
Observe and ascertain holiday rentals in Reed City United States and home rentals Reed City United States.
Our for rent by owner website eliminates quarter, city, turf, and zone score, at times.
Ferret out and determine rent houses Gladwin Michigan and holiday rentals.
Uncover, look up, and perceive Oakland Michigan holiday rentals, houses for rent, Oakland for rent by owner homes, and home rentals Oakland.
Ferret out and dig up Temperance United States bed and breakfast rentals and rental homes Temperance.
|
|
