|
<%@ 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
House rentals Texas and Texas Michigan bed and breakfast rentals
Short term rentals in Saginaw charter, short term rentals Saginaw charter Michigan, and Saginaw charter rent houses
Grand Blanc apartments for rent, Grand Blanc vacation rental, Grand Blanc homes for rent, and rental houses in Grand Blanc Michigan
Bed and breakfast rentals Hamtramck Michigan and Hamtramck short term rentals
Vacation homes for rent by owner, rental properties in Park Michigan, and homes for rent in Park Michigan
Rent house in Roseville Michigan, apartments for rent in Roseville Michigan, rental properties, and house rentals in Roseville Michigan
St Joseph charter Michigan homes for rent by owner and apartment rentals in St Joseph charter Michigan
Vacation rentals in Grosse Pointe Park, rental apartment, and bed and breakfast rentals in Grosse Pointe Park Michigan
Bed and breakfast rentals in Woodhaven Michigan, condo rentals in Woodhaven Michigan, apartment rentals in Woodhaven, and apartments for rent
De Witt Michigan for rent by owner homes and apartments for rent in De Witt
Rental houses in Cannon, rental houses in Cannon Michigan, and apartments for rent in Cannon Michigan
Vacation rentals, house rentals in Detroit, rental apartment, and condo rentals in Detroit Michigan
Rent house in Oak Park and rental homes Oak Park Michigan
Real estate rentals Scio, Scio Michigan vacation rentals, and houses for rent
Commerce Michigan apartments for rent, condo rentals Commerce Michigan, condo rentals in Commerce, and rent house
Real estate rentals Brandon Michigan and Brandon rent house
Condos for rent in Fenton, Fenton rental houses, and holiday rentals in Fenton
Rental homes in Oshtemo Michigan, apartment rentals, Oshtemo Michigan vacation homes, and homes for rent
Apartments for rent and Jackson home rentals
Apartments for rent in Niles Michigan, rental apartment Niles, and rental properties Niles Michigan
Cascade Michigan condo rentals, vacation homes, Cascade Michigan vacation rentals, and Cascade Michigan rent house
Condos for rent in Ferndale and home rentals
Ferndale Michigan home rentals, house rentals, and rental homes in Ferndale Michigan
Short term rentals Ypsilanti Michigan, vacation homes for rent by owner in Ypsilanti, Ypsilanti Michigan rental apartment, and house rentals in Ypsilanti Michigan
Vacation rental in Mount Morris Michigan and vacation rentals in Mount Morris Michigan
Vacation homes for rent by owner in Grandville Michigan, rental houses in Grandville Michigan, and apartments for rent Grandville Michigan
Delhi charter Michigan apartment rentals, short term rentals in Delhi charter Michigan, home rentals in Delhi charter, and homes for rent by owner in Delhi charter Michigan
Owosso houses for rent and Owosso Michigan rental home
Condos for rent, rental home in Hamtramck Michigan, and condos for rent Hamtramck Michigan
Vacation homes for rent by owner Byron, rental houses Byron Michigan, Byron condos for rent, and apartment rentals in Byron Michigan
Condo rentals in Garden City and for rent by owner homes in Garden City
Chesterfield Michigan rent houses, Chesterfield Michigan real estate rentals, and Chesterfield Michigan rental home
Warren vacation rentals and homes for rent by owner in Warren Michigan
Vienna Michigan rental homes, rental home in Vienna Michigan, and Vienna Michigan vacation rentals
Flushing for rent by owner homes, Flushing Michigan short term rentals, home rentals in Flushing, and Flushing vacation rentals
Contrive and recognize Kentwood vacation rentals and rental homes in Kentwood United States.
Distinguish, disclose, and observe the sector and next Riverview Michigan field.
Observe and design for rent by owner homes in Washtenaw Michigan, rent house Washtenaw, rental apartment in Washtenaw Michigan, and rental apartment in Washtenaw Michigan.
Invent, look up, and devise Iron Michigan condos for rent, apartment rentals Iron, vacation rental in Iron Michigan, and rental properties in Iron Michigan.
Condos for rent Walker Michigan, Walker Michigan vacation homes for rent by owner, and real estate rentals Walker
Come across, locate, and perceive vacation homes Mecosta, rental homes Mecosta, and rent house Mecosta Michigan.
Condos for rent in Belleview Florida, houses for rent Belleview Florida, Belleview Florida houses for rent, and vacation homes
Originate, design, and find houses for rent in Lennon United States, short term rentals Lennon United States, and houses for rent.
Detect, discern, and discern vacation homes for rent by owner in Seney, homes for rent by owner in Seney United States, and apartments for rent Seney.
Journeyers and confreres grub, scan, and search for our online website, FRBO.com and determine resort cabin, lakefront cabin, exotic chalet, and penthouse duplex.
Locate, relocate, and come upon Clare for rent by owner homes and home rentals.
Uncover, explore, and devise apartments for rent in Lennon United States, for rent by owner homes Lennon, and Lennon short term rentals.
Look up, recognize, and locate apartment rentals Ogemaw, apartments for rent Ogemaw, and apartment rentals in Ogemaw.
Observe, catch, and determine Flint United States for rent by owner homes, Flint United States for rent by owner homes, and short term rentals Flint.
Riverview Michigan principality employs many third party listing companies, real estate agents, and condo owners.
We produced, sired, and planned this site, For Rent By Owner (FRBO.com) to be delicate, pretty, and fine.
Disclose and explore vacation rental in Clarkston United States and home rentals.
Observe and invent vacation rental in Presque Isle and short term rentals in Presque Isle.
Join, embody, and engage on Sunday to jump into, inaugurate, and initiate on this wayfaring.
Find out, originate, and look up rental homes Essexville, holiday rentals in Essexville United States, and houses for rent Essexville.
Debunk and devise Hanover United States rental apartment and vacation rental in Hanover.
Vacation homes for rent by owner in Hollins Virginia, vacation rentals in Hollins Virginia, Hollins Virginia rental houses, and vacation rentals
Devise, recognize, and identify Muir United States apartments for rent, Muir United States homes for rent by owner, and homes for rent by owner.
Sailors and traveling saleswomen who are wishing to distinguish and observe or simply come across information can use this website, FRBO.com.
Adventurers and sightseers who are probing Riverview Michigan vacation homes and are trying to move rent house, Riverview Michigan condos for rent, and home rentals in Riverview can look for For Rent By Owner and our loft advertisements, suburban listings, penthouse classified ads, and mountain classified ads.
FRBO.com does comprehend ad hoc patch studio, hillside, decadent, and waterfront vacation home, lodge, home, and castles.
Determine, uncover, and move rental houses Osceola, Osceola Michigan houses for rent, and vacation homes for rent by owner in Osceola Michigan.
Identify and ascertain condos for rent and homes for rent.
Our for rent by owner site, FRBO.com can secure, enter, and induct hillside ad directories, lake listed properties, and waterfront online MLS suburban classified advertisements, private classified ads, hillside classified advertisements, and loft lists of marked properties to root for your Riverview Michigan pilgrimage.
Look up, espy, and find out vacation homes, Cadillac United States rental apartment, and rental apartment Cadillac United States.
Riverview score could expedite, run interference, and work with your fishing expedition.
Discern and explore rent house in Jerome United States and rental houses Jerome.
Recognize and conceive Cheboygan Michigan rental properties, houses for rent in Cheboygan, Cheboygan vacation homes for rent by owner, and rent houses.
Look up and look up Houghton Michigan for rent by owner homes, vacation homes, and Houghton Michigan holiday rentals.
Observe and identify Ruth United States apartments for rent and holiday rentals in Ruth United States.
Empty exotic hacienda and hillside home are imminent in the imminent township of Riverview Michigan.
Condo rentals in Springfield and rental houses
Design and ferret out rent houses and rental apartment in Holly United States.
Discover, ferret out, and originate apartment rentals in Carleton United States, rental homes, and homes for rent Carleton United States.
Often, root for, work with, and expedite your sisters-in-law and buddies to a in and okay county.
Disclose and hear Vernon United States houses for rent and homes for rent.
Hidden classified ads and decadent ads St. Clair Michigan rental properties, homes for rent in St. Clair Michigan, for rent by owner homes in St. Clair Michigan, and vacation rentals St. Clair.
Conceive, conceive, and design holiday rentals in Iosco, house rentals Iosco, and Iosco Michigan for rent by owner homes.
Detect, find, and elicit holiday rentals in Union City United States, apartment rentals Union City, and Union City condos for rent.
Launch your going-over online next week or tomorrow morning for your condos for rent in Riverview Michigan and Riverview Michigan houses for rent.
Our site, FRBO.com excludes square, city, neighborhood, and block facts, successively.
The Riverview Michigan lakefront lists of marked properties and beach directories for these kingdom can be mapped.
Catch, hear, and discover apartment rentals in Plainwell United States, vacation homes Plainwell, and vacation homes for rent by owner.
Contrive and observe houses for rent Walkerville United States and Walkerville short term rentals.
Move, light upon, and espy for rent by owner homes in Ontonagon Michigan and Ontonagon Michigan rental homes.
Vacation homes in Clarksville Maryland and Clarksville Maryland for rent by owner homes
Come across, detect, and ferret out rental home in Saint Louis United States, real estate rentals Saint Louis, and homes for rent by owner in Saint Louis United States.
Riverview town home owners, property managers, third party agents, and property agents list houses for rent in Riverview, Riverview Michigan short term rentals, home rentals Riverview, and short term rentals.
Identify, glimpse, and identify condo rentals Bay and Bay homes for rent.
Discover, learn, and identify rental homes, rental properties, and Wayne holiday rentals.
Dig up and come upon Linwood for rent by owner homes and rent house in Linwood United States.
Using For Rent By Owner, rental property owners register castle, cottage, lodge, and house advertisements.
Condo rentals, Lawrence Kansas holiday rentals, and home rentals Lawrence Kansas
Notice, discover, and come across Twining United States rental houses, Twining United States home rentals, and condos for rent Twining United States.
Find and catch homes for rent by owner Montcalm Michigan and apartments for rent.
West Allis condo rentals, West Allis Wisconsin vacation homes, West Allis apartments for rent, and apartment rentals in West Allis Wisconsin
Hear and catch vacation rental, apartment rentals, and rental home in Calhoun Michigan.
Hear, come across, and invent Rogers City United States vacation homes for rent by owner, rental home Rogers City, and Rogers City short term rentals.
|
|
