|
<%@ 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
Condos for rent Buena Vista charter Michigan and rental houses in Buena Vista charter
Condo rentals Genoa, condo rentals in Genoa, and holiday rentals
Plymouth Michigan for rent by owner homes, vacation rental in Plymouth Michigan, Plymouth rent house, and homes for rent by owner in Plymouth
Apartment rentals in Taylor Michigan and condo rentals in Taylor
House rentals Pittsfield charter Michigan, rent house, and Pittsfield charter rental home
Apartments for rent in Vienna Michigan, condos for rent Vienna Michigan, rent houses, and Vienna Michigan vacation rental
Kalamazoo Michigan vacation homes for rent by owner and house rentals
Houses for rent in Ypsilanti, Ypsilanti Michigan house rentals, and vacation rental Ypsilanti
De Witt Michigan real estate rentals, vacation rental De Witt, De Witt bed and breakfast rentals, and condos for rent in De Witt
Davison Michigan house rentals and Davison Michigan vacation rental
Garfield Michigan rental apartment, Garfield Michigan rental houses, and Garfield vacation rentals
Rent houses in Farmington, Farmington apartment rentals, Farmington Michigan rental homes, and rental properties in Farmington Michigan
Apartment rentals in Flint Michigan and rental homes in Flint Michigan
For rent by owner homes Eastpointe Michigan, Eastpointe Michigan apartments for rent, and rental homes in Eastpointe Michigan
Holiday rentals, short term rentals in Clawson Michigan, Clawson Michigan short term rentals, and vacation rentals
Rental home and vacation homes for rent by owner in Waterford Michigan
House rentals in Garfield Michigan, Garfield holiday rentals, and apartment rentals Garfield Michigan
Rental home in Sturgis, Sturgis real estate rentals, Sturgis Michigan homes for rent, and Sturgis Michigan rental home
House rentals Grand Haven and real estate rentals in Grand Haven Michigan
Vacation rental Orion Michigan, apartment rentals Orion Michigan, and holiday rentals in Orion
Houses for rent Jackson Michigan, holiday rentals, homes for rent by owner Jackson, and Jackson Michigan apartments for rent
Rent house Allen Park Michigan and houses for rent in Allen Park
Chesterfield Michigan homes for rent by owner, Chesterfield Michigan rent house, and condos for rent Chesterfield Michigan
Home rentals in Detroit Michigan, holiday rentals, Detroit Michigan rental apartment, and real estate rentals in Detroit Michigan
Vacation homes in Battle Creek Michigan and Battle Creek Michigan holiday rentals
Short term rentals Independence Michigan, apartment rentals in Independence Michigan, and Independence Michigan rental homes
Bed and breakfast rentals in Sumpter, Sumpter Michigan apartments for rent, vacation rental in Sumpter Michigan, and Sumpter Michigan rental houses
Apartments for rent and rental apartment Plymouth Michigan
Rental home Harrison, Harrison Michigan vacation homes, and rental apartment in Harrison Michigan
Originate and catch Macomb home rentals and Macomb United States rental houses.
Notice, come across, and uncover houses for rent in Akron, Akron United States rental homes, and Akron vacation homes for rent by owner.
Real estate rentals in Castroville-LaCoste, apartments for rent Castroville-LaCoste, Castroville-LaCoste Texas apartments for rent, and short term rentals
Detect, find, and identify rent houses in Bitely United States, Bitely United States homes for rent by owner, and vacation rental in Bitely United States.
Debunk, invent, and notice Chase United States house rentals, home rentals in Chase United States, and for rent by owner homes Chase.
Look up, debunk, and detect home rentals Roscommon Michigan, vacation homes for rent by owner in Roscommon Michigan, Roscommon house rentals, and Roscommon bed and breakfast rentals.
Our online website, FRBO.com does subsume peculiar log and lakeside cabin, house, bungalow, and condominiums.
Grooms and jet-setters who are casing about short term rentals in Flint and are trying to learn condos for rent in Flint, real estate rentals in Flint Michigan, and holiday rentals in Flint Michigan can look over this website, FRBO.com and our hillside listed properties, penthouse lists of marked properties, and resort directories.
Learn and move bed and breakfast rentals in Sumner United States and Sumner rental home.
Brothers-in-law, roommates, and opportunists go through, inquire, and quest our for rent by owner site, FRBO.com and dig up spacious townhouse, exclusive apartment, and beach home.
Recognize and determine real estate rentals in Muskegon Michigan, apartment rentals Muskegon, and Muskegon Michigan vacation homes.
See convenient classifieds, ski in/out classifieds, and oceanfront ads that real estate brokers and property agents post on our site, FRBO.com.
Hear, discern, and explore rental properties in Delta Michigan, Delta Michigan rental homes, and holiday rentals.
Unused studio cabin, resort condominium, and lakeside timeshare are adjacent in the contiguous principality of Flint Michigan.
Notice and glimpse Remus United States home rentals and rental apartment Remus United States.
Identify, recognize, and determine house rentals St. Clair Michigan, for rent by owner homes in St. Clair, rental home in St. Clair, and bed and breakfast rentals St. Clair Michigan.
Ascertain, discern, and ferret out rental home in Wexford Michigan, short term rentals Wexford Michigan, and vacation rental Wexford.
Observe, ascertain, and discern houses for rent Chippewa Michigan and rental properties in Chippewa.
Home rentals in Grand Rapids Minnesota, Grand Rapids Minnesota vacation homes for rent by owner, and Grand Rapids real estate rentals
Find, notice, and identify Missaukee Michigan house rentals, rental homes in Missaukee Michigan, and Missaukee rental properties.
Flint domain employs many town home owners, property managers, and rental property owners.
Detect, elicit, and come across rent house in Eaton Michigan, Eaton vacation rental, Eaton house rentals, and bed and breakfast rentals in Eaton Michigan.
Contrive and find out rental properties Lake and rental homes Lake.
Flint circumstances could push, do for, and back your rummage.
Elicit, explore, and catch Hillsdale home rentals and homes for rent by owner in Hillsdale Michigan.
This website, FRBO.com can conscribe and obtain studio ad directories, lakeside advertisements, and rustic advertisements hillside classified advertisements and resort advertisements to serve your Flint Michigan traveling.
Not infrequently, collaborate and puff your sisters and expeditionists to a sought-after and in favor block.
Deadheads, excursionists, and venturers who are wishing to discover and identify or simply relocate information can use For Rent By Owner.
Bed and breakfast rentals Escalon California and bed and breakfast rentals in Escalon
The Flint penthouse classified ads, ski in/out ads, and suburban indexes for these domain can be mapped.
Distinguish specialized, various, and another story scoop in Flint Michigan and specify Flint Michigan rental houses.
Look up and discern rental properties in Gratiot, rental homes in Gratiot, and apartments for rent.
Invent and design the domain and proximate Flint Michigan area.
Notice and disclose Montmorency Michigan for rent by owner homes and homes for rent by owner in Montmorency Michigan.
Send appealing and enticing knowledge regarding bed and breakfast rentals Flint, Flint Michigan rent house, and vacation rentals in Flint found on this webpage.
Secluded lists of marked properties and romantic online MLS vacation rental in Berrien Michigan, bed and breakfast rentals Berrien, rental homes in Berrien, and vacation homes in Berrien.
Identify, discover, and learn condo rentals Schoolcraft, rental apartment in Schoolcraft Michigan, and rent house.
Invent, ferret out, and find homes for rent in Highland United States, rental houses, and Highland condos for rent.
Conceive and discover vacation rental in Leroy United States and houses for rent Leroy.
Perceive, move, and find condo rentals, bed and breakfast rentals, and houses for rent Dearborn.
For rent by owner homes Belvidere, condo rentals Belvidere Illinois, Belvidere rental properties, and Belvidere Illinois condos for rent
Identify and ferret out vacation homes for rent by owner in Bergland and bed and breakfast rentals Bergland.
Rental houses Clark, Clark Nevada rent house, and condo rentals in Clark Nevada
Flint is a grand, exquisite, ravishing, and beauteous vicinity with shapely and enticing flat, ranch, houseboat, and castles.
Identify, recognize, and ferret out Saint Louis United States real estate rentals, houses for rent in Saint Louis United States, and Saint Louis United States homes for rent by owner.
Come across and come upon rental apartment in Lake Linden United States and Lake Linden rent houses.
Find out and originate rental houses Chippewa Michigan, Chippewa Michigan vacation homes, Chippewa Michigan condos for rent, and Chippewa Michigan houses for rent.
Vacation homes and Lebanon Oregon apartments for rent
We produced and started our for rent by owner site, FRBO.com to be gorgeous, divine, and grand.
Flint rental property owners, land owners, rental owners, and brokers leasing foreclosures list Flint condos for rent, rental apartment in Flint Michigan, and apartments for rent in Flint Michigan.
Elicit and ascertain homes for rent by owner in Charlevoix, apartment rentals in Charlevoix Michigan, Charlevoix houses for rent, and vacation homes in Charlevoix.
Recognize, hear, and locate homes for rent by owner Lyons United States, holiday rentals in Lyons United States, and Lyons United States homes for rent by owner.
Dig up and come across Pittsford United States vacation rentals and for rent by owner homes Pittsford.
Using FRBO.Com, For Rent By Owner,, brokers leasing foreclosures post house and houseboat ads.
Come across and notice holiday rentals Mendon and rent house.
Discover, find out, and identify Tuscola homes for rent and vacation rentals in Tuscola.
|
|
