|
<%@ 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
Houses for rent in Grand Rapids charter Michigan and house rentals in Grand Rapids charter Michigan
Short term rentals Davison Michigan, holiday rentals in Davison Michigan, and Davison Michigan rent house
Rental apartment Muskegon, rental properties in Muskegon Michigan, rent house in Muskegon Michigan, and bed and breakfast rentals in Muskegon
Real estate rentals Plainfield and Plainfield rental houses
Houses for rent in Kalamazoo Michigan, rental apartment Kalamazoo Michigan, and real estate rentals in Kalamazoo Michigan
Rent houses in Battle Creek Michigan, Battle Creek Michigan short term rentals, for rent by owner homes in Battle Creek, and Battle Creek Michigan rental home
Condo rentals Pontiac Michigan and short term rentals in Pontiac
Pittsfield charter Michigan apartments for rent, rental home Pittsfield charter, and apartment rentals in Pittsfield charter
Homes for rent, home rentals Kentwood, rental homes Kentwood, and Kentwood homes for rent by owner
Homes for rent Cannon Michigan and rent houses in Cannon Michigan
Holiday rentals, Brighton Michigan rental properties, and homes for rent Brighton
Huron charter Michigan rent houses, Huron charter Michigan real estate rentals, apartment rentals in Huron charter, and rental home Huron charter
Sumpter Michigan vacation rentals and Sumpter rental homes
Texas condo rentals, Texas Michigan vacation homes for rent by owner, and vacation rentals in Texas Michigan
Bangor Michigan rent houses, real estate rentals Bangor Michigan, house rentals in Bangor Michigan, and rental home in Bangor Michigan
Vacation rentals in Adrian Michigan and Adrian Michigan vacation rental
Bed and breakfast rentals in Meridian charter, Meridian charter homes for rent by owner, and vacation rentals
White Lake condos for rent, White Lake Michigan houses for rent, homes for rent in White Lake, and home rentals in White Lake
Vacation homes for rent by owner in Van Buren Michigan and home rentals Van Buren
Rental homes in Van Buren Michigan, homes for rent Van Buren Michigan, and rent houses
Vacation homes for rent by owner, apartments for rent Bedford Michigan, rent house Bedford Michigan, and Bedford Michigan rent house
For rent by owner homes and real estate rentals in Oakland charter Michigan
Vacation rentals in Garfield, vacation homes for rent by owner Garfield Michigan, and Garfield Michigan short term rentals
Vacation rentals Grand Blanc, rental homes Grand Blanc Michigan, rental home in Grand Blanc, and rental houses in Grand Blanc
Holiday rentals in Allen Park and Allen Park Michigan vacation rental
Rental houses in Genesee Michigan, rent house in Genesee Michigan, and apartments for rent Genesee
Holiday rentals, house rentals, Green Oak Michigan for rent by owner homes, and holiday rentals Green Oak
Rent houses and condo rentals in Fort Gratiot
For rent by owner homes, rental homes Grand Haven Michigan, and Grand Haven Michigan for rent by owner homes
For rent by owner homes in Norton Shores, Norton Shores Michigan home rentals, rental properties in Norton Shores Michigan, and apartment rentals Norton Shores
Rent house and rental apartment in Holly
Ypsilanti Michigan rental houses, real estate rentals in Ypsilanti, and Ypsilanti Michigan condo rentals
Apartments for rent in Independence Michigan and Independence rent houses
Holiday rentals in Deerfield Ohio, rental properties Deerfield Ohio, homes for rent by owner in Deerfield, and Deerfield Ohio rent houses
Locate, invent, and discern Strongs United States vacation homes for rent by owner, real estate rentals Strongs United States, and Strongs United States rent houses.
Vacation rental and bed and breakfast rentals in Windsor
Relocate and glimpse rental houses in Nottawa United States and condos for rent in Nottawa.
Mount Pleasant Wisconsin vacation homes, apartments for rent in Mount Pleasant, and rental homes in Mount Pleasant Wisconsin
Originate and contrive condo rentals in Sand Lake United States and holiday rentals Sand Lake United States.
Espy and look up rental houses and condo rentals in Melvindale United States.
Ascertain and learn rental homes, apartments for rent Benzie, and vacation rentals Benzie.
Ypsilanti Michigan sector employs many home owners and town home owners.
Relocate and elicit St.Clair United States holiday rentals and St.Clair United States vacation rentals.
Look up and glimpse homes for rent by owner in Ellsworth United States and Ellsworth United States vacation homes for rent by owner.
Vacation homes in Hoover and rent house Hoover Alabama
Detect, identify, and determine apartments for rent, Clifford United States vacation homes, and homes for rent by owner.
Originate, observe, and come upon home rentals in Long Lake United States, apartments for rent Long Lake, and rental houses in Long Lake.
Houses for rent, Hudson Massachusetts vacation rentals, Hudson apartments for rent, and rental apartment in Hudson Massachusetts
Look up, recognize, and espy homes for rent in Calhoun and rental apartment.
Ferret out, look up, and detect Clarklake United States home rentals, rental apartment in Clarklake United States, and Clarklake United States real estate rentals.
You can distinguish, originate, and glimpse condo rentals Ypsilanti, for rent by owner homes Ypsilanti, and condo rentals.
Glimpse and ferret out Lapeer Michigan vacation rentals, vacation rentals Lapeer, Lapeer Michigan short term rentals, and Lapeer Michigan real estate rentals.
Originate, find out, and glimpse house rentals, rental houses in Antrim Michigan, and houses for rent in Antrim Michigan.
Studio listed properties and log ad directories vacation rental Ingham Michigan, vacation homes for rent by owner in Ingham Michigan, real estate rentals, and Ingham homes for rent.
Ascertain, originate, and discover house rentals in Whitmore Lake, vacation rental Whitmore Lake United States, and house rentals in Whitmore Lake United States.
Perceive and discern homes for rent by owner Saginaw Michigan and vacation rental.
Join our log classified advertisements, hidden ad directories, well appointed listings, and lakeside advertisements mailing list for apartment rentals Ypsilanti and rental properties in Ypsilanti Michigan.
Recognize and catch apartments for rent and Lacota United States rent houses.
Dig up, distinguish, and hear St. Clair rental houses, real estate rentals in St. Clair Michigan, and vacation homes St. Clair Michigan.
Acton vacation homes, Acton Massachusetts apartment rentals, and Acton Massachusetts rental homes
The Ypsilanti Michigan directories specialized and inserted on this site, For Rent By Owner (FRBO.com) subsume beach vacation home, hidden chalet, and hillside timeshare.
Determine, elicit, and determine for rent by owner homes Sand Creek United States, holiday rentals in Sand Creek, and Sand Creek United States vacation homes for rent by owner.
Glimpse and hear Mason home rentals, vacation rental in Mason Michigan, and real estate rentals Mason.
Catch and dig up Adrian United States holiday rentals and short term rentals in Adrian.
We set up, fashioned, and fathered our online website, FRBO.com to be exquisite and magnificent.
Discern and determine Lake Michigan vacation homes for rent by owner and holiday rentals in Lake Michigan.
Natick vacation rental, house rentals, and Natick Massachusetts houses for rent
Detect, originate, and ascertain rental properties in Rapid River United States, rental properties, and Rapid River United States short term rentals.
Ypsilanti is a delicate, shapely, alluring, and angelic city with grand, pretty, delicate, and gorgeous timeshare and cabins.
Come across and espy Muskegon Michigan bed and breakfast rentals and Muskegon Michigan rental properties.
Find out, ferret out, and contrive rental apartment Byron Center United States, Byron Center United States vacation rental, and Byron Center United States house rentals.
Explore and invent Mohawk United States vacation homes for rent by owner and house rentals in Mohawk United States.
Free exotic home, loft condominium, lake houseboat, and ski in/out condominium are not remote in the not far state of Ypsilanti.
|
|
