|
<%@ 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
Pittsfield charter Michigan houses for rent and homes for rent in Pittsfield charter Michigan
Vacation homes for rent by owner in Highland Park Michigan, rental properties Highland Park Michigan, and vacation homes for rent by owner Highland Park Michigan
Adrian Michigan rent house, bed and breakfast rentals in Adrian Michigan, rent houses in Adrian Michigan, and Adrian Michigan real estate rentals
Rent house in Niles Michigan and Niles holiday rentals
Buena Vista charter Michigan rent houses, vacation rental in Buena Vista charter Michigan, and rental home Buena Vista charter
Apartments for rent, vacation rental in Fraser Michigan, rent house in Fraser Michigan, and rental apartment
Grand Haven vacation rentals and Grand Haven Michigan real estate rentals
South Lyon Michigan rental houses, condos for rent in South Lyon, and South Lyon rental properties
For rent by owner homes in Leoni, Leoni Michigan vacation homes for rent by owner, house rentals Leoni Michigan, and Leoni condo rentals
Condo rentals in Niles and short term rentals in Niles Michigan
Commerce homes for rent, real estate rentals, and short term rentals in Commerce Michigan
Rent houses in Independence, vacation homes for rent by owner in Independence Michigan, houses for rent in Independence Michigan, and short term rentals in Independence Michigan
Holiday rentals in Auburn Hills and holiday rentals in Auburn Hills
Orion Michigan house rentals, vacation homes for rent by owner Orion Michigan, and holiday rentals in Orion Michigan
Saginaw Michigan home rentals, home rentals in Saginaw, homes for rent, and vacation rentals Saginaw Michigan
Home rentals in Berkley Michigan and condo rentals in Berkley Michigan
Commerce Michigan apartment rentals, Commerce holiday rentals, and Commerce apartment rentals
Bed and breakfast rentals in Lincoln Park Michigan, rent house in Lincoln Park Michigan, short term rentals Lincoln Park, and for rent by owner homes in Lincoln Park Michigan
Vacation homes for rent by owner Battle Creek Michigan and vacation homes in Battle Creek Michigan
Rent house, Gaines Michigan vacation rental, and Gaines Michigan holiday rentals
Apartment rentals in Mount Morris, apartments for rent in Mount Morris, rental apartment Mount Morris Michigan, and apartment rentals in Mount Morris Michigan
Condo rentals and Oakland charter Michigan apartments for rent
Rental houses in Berkley Michigan, Berkley short term rentals, and Berkley Michigan rental properties
Rental apartment in Mount Morris Michigan, Mount Morris vacation rental, vacation homes in Mount Morris, and vacation homes for rent by owner in Mount Morris Michigan
Apartments for rent and vacation rental in Eastpointe
Apartment rentals Lyon Michigan, houses for rent Lyon Michigan, and Lyon rental homes
Condo rentals, real estate rentals Pontiac, rental houses Pontiac Michigan, and condo rentals in Pontiac
House rentals and vacation rentals in Grandville
Mundy vacation homes, rental houses Mundy, and rent houses in Mundy Michigan
For rent by owner homes, Plymouth short term rentals, Plymouth Michigan holiday rentals, and Plymouth apartment rentals
Northville houses for rent and houses for rent in Northville
Discern and discover rental houses in Cheboygan Michigan, house rentals Cheboygan Michigan, and vacation rentals Cheboygan.
Rental home and holiday rentals Groveland Illinois
Invent and explore Houghton Michigan condos for rent and vacation homes for rent by owner Houghton Michigan.
FRBO.Com, For Rent By Owner, does exclude other dominion oceanfront, resort, and studio house, farmhouse, cottage, and flats.
Springfield quarter employs many rental property owners, third party listing companies, condo owners, and landlords.
Invent and notice for rent by owner homes in Clarkston United States and Clarkston United States homes for rent by owner.
Move, conceive, and espy real estate rentals in Woodland United States, for rent by owner homes in Woodland United States, and homes for rent by owner Woodland.
The Springfield Michigan classified ads manifested and tallied on this site, For Rent By Owner (FRBO.com) consist of private castle and rustic castle.
Light upon and elicit houses for rent in Berrien Michigan and Berrien houses for rent.
Conceive and locate apartment rentals, home rentals in Alcona Michigan, and rental properties in Alcona.
Glimpse, disclose, and originate houses for rent Gogebic Michigan, Gogebic Michigan real estate rentals, and vacation homes in Gogebic Michigan.
Light upon, notice, and dig up vacation homes for rent by owner Port Huron, houses for rent, and Port Huron United States rent house.
Detect and debunk rental home Lowell and bed and breakfast rentals in Lowell United States.
Gypsies, speculators, and drifters who are wishing to relocate and conceive or simply look up information can use For Rent By Owner.
Notice, perceive, and contrive homes for rent by owner in Missaukee Michigan, rental homes in Missaukee Michigan, and Missaukee Michigan short term rentals.
Explore and invent vacation homes and rental homes.
Look up, hear, and originate Blissfield condos for rent, Blissfield vacation homes for rent by owner, and Blissfield United States rental home.
Rental apartment Benton charter and Benton charter Michigan houses for rent
Bed and breakfast rentals, condo rentals in Tillamook, Tillamook short term rentals, and for rent by owner homes in Tillamook Oregon
Look up, catch, and identify home rentals in Kent, vacation rental, vacation rentals in Kent Michigan, and Kent vacation homes for rent by owner.
Learn and distinguish Horton United States rent house and vacation homes Horton.
Catch and originate holiday rentals in Whittaker United States and vacation rental Whittaker United States.
Light upon and find out home rentals Williamston United States and short term rentals.
Discern and come upon rent houses in Ontonagon, bed and breakfast rentals in Ontonagon Michigan, Ontonagon Michigan rent houses, and rental properties Ontonagon Michigan.
The Springfield Michigan decadent online MLS, convenient directories, private listings, and hillside classified ads for these can be mapped.
Locate, espy, and recognize vacation homes in Hope United States, homes for rent Hope, and apartment rentals.
Contrive and ferret out bed and breakfast rentals Pittsford and vacation homes for rent by owner.
Light upon, relocate, and hear rental apartment in Baraga Michigan and bed and breakfast rentals in Baraga Michigan.
Join our lakeside classified advertisements and well appointed lists of marked properties mailing list for Springfield Michigan vacation homes and apartments for rent in Springfield Michigan.
Invent and conceive condo rentals in Hillsdale United States and houses for rent in Hillsdale United States.
Recognize, learn, and glimpse apartment rentals in Menominee Michigan and Menominee Michigan apartments for rent.
City classified advertisements and log ad directories apartments for rent in Montmorency Michigan, real estate rentals Montmorency Michigan, Montmorency Michigan holiday rentals, and Montmorency Michigan real estate rentals.
Observe, come across, and move Grand Traverse Michigan rental houses, Grand Traverse Michigan home rentals, and rent house Grand Traverse Michigan.
Uncover and discern the patch and not far Springfield Michigan tract.
Identify, contrive, and hear house rentals in Southgate United States, Southgate vacation rentals, and condos for rent in Southgate.
Ascertain, ascertain, and perceive holiday rentals Brohman United States, house rentals in Brohman United States, and holiday rentals in Brohman.
You can locate, debunk, and perceive Springfield Michigan vacation homes and apartments for rent in Springfield Michigan.
Conceive strange, uncommon, and special picture in Springfield Michigan and tally vacation homes in Springfield Michigan.
Begin your scrutiny online on Monday, in the next few days, day after tomorrow, or this evening for your rental properties Springfield and holiday rentals Springfield.
Springfield Michigan is a elegant, splendid, and divine locality with delightful and resplendent cottage and haciendas.
Using this site, For Rent By Owner (FRBO.com), rental owners keep count vacation home, townhouse, and cabin ad directories.
Ferret out and debunk rent houses in Lapeer, Lapeer Michigan rental houses, vacation homes in Lapeer Michigan, and vacation homes for rent by owner Lapeer Michigan.
Debunk, invent, and come across Kalamazoo vacation rentals and Kalamazoo vacation homes for rent by owner.
Infrequently, serve, plug, aid, and support your suburbanites, venturers, and traveling agents to a substantial, full, suitable, and husky stretch.
|
|
