|
<%@ 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" %>
|
Texas Rental Links
Rental apartment in McKinney Texas and vacation rentals in McKinney Texas
Rental properties in Princeton, Princeton Texas vacation rental, and Princeton bed and breakfast rentals
Vacation rental, vacation homes for rent by owner, Corpus Christi Texas real estate rentals, and rental properties Corpus Christi Texas
Houses for rent Pilot Point-Aubrey Texas and Pilot Point-Aubrey vacation homes for rent by owner
Houses for rent in Wichita Falls, home rentals Wichita Falls Texas, and real estate rentals Wichita Falls Texas
Short term rentals in Beaumont, rent house Beaumont Texas, real estate rentals Beaumont Texas, and Beaumont Texas bed and breakfast rentals
Holiday rentals and Stafford-Missouri City Texas vacation homes
East Grayson Texas rental home, rental home East Grayson Texas, and real estate rentals in East Grayson Texas
Vacation homes for rent by owner in Corpus Christi West Texas, vacation rentals Corpus Christi West Texas, real estate rentals Corpus Christi West, and rental apartment in Corpus Christi West Texas
Apartment rentals in Stafford-Missouri City and rental properties Stafford-Missouri City Texas
Apartment rentals in Springtown Texas, Springtown condos for rent, and vacation homes in Springtown
Rental apartment Pilot Point-Aubrey, Pilot Point-Aubrey Texas vacation rental, rental home in Pilot Point-Aubrey, and Pilot Point-Aubrey Texas rental properties
Vacation rental and vacation rental in Travis Northwest
Kaufman real estate rentals, vacation rental in Kaufman, and Kaufman Texas rent house
Rental properties Fort Hood Texas, Fort Hood Texas homes for rent, rental houses in Fort Hood, and Fort Hood Texas real estate rentals
Rental apartment in El Campo Texas and homes for rent by owner in El Campo Texas
Vidor short term rentals, rent house in Vidor Texas, and rental home in Vidor
Liberty Hill-Cedar Park Texas for rent by owner homes, Liberty Hill-Cedar Park Texas vacation rental, Liberty Hill-Cedar Park for rent by owner homes, and Liberty Hill-Cedar Park vacation rentals
Home rentals in Waller Texas and apartments for rent
Mount Pleasant Texas houses for rent, Mount Pleasant rental houses, and Mount Pleasant Texas rent house
Bandera vacation homes for rent by owner, for rent by owner homes Bandera Texas, homes for rent by owner Bandera Texas, and homes for rent in Bandera
Short term rentals Cedar Creek-Red Rock and Cedar Creek-Red Rock rental apartment
Forney Texas condos for rent, houses for rent Forney, and Forney Texas vacation homes
Burkburnett Texas home rentals, vacation rentals in Burkburnett, homes for rent by owner in Burkburnett Texas, and condos for rent in Burkburnett Texas
Abilene Texas rental home and rental apartment
Vacation rentals in Edinburg Texas, Edinburg Texas condo rentals, and Edinburg home rentals
Amarillo rental home, Amarillo Texas houses for rent, rental home in Amarillo Texas, and vacation rentals in Amarillo Texas
Vacation homes for rent by owner Lindale and bed and breakfast rentals Lindale
Homes for rent by owner in Plano, vacation rental in Plano Texas, and rental home in Plano Texas
Vacation homes for rent by owner in Taylor, Taylor Texas condo rentals, short term rentals Taylor Texas, and apartment rentals in Taylor Texas
Rent house in East Jefferson Texas and apartment rentals in East Jefferson Texas
Snyder Texas bed and breakfast rentals, rent house in Snyder Texas, and for rent by owner homes Snyder
Catch and debunk rent house and apartments for rent Olney United States.
Learn, dig up, and find Stonewall vacation homes for rent by owner and vacation homes for rent by owner in Stonewall Texas.
Charleston-North Charleston South Carolina rental properties, Charleston-North Charleston South Carolina condo rentals, and rent house Charleston-North Charleston South Carolina
Design, recognize, and determine rental home, houses for rent in Matador United States, and Matador bed and breakfast rentals.
We phrased, effected, and composed this site, FRBO.com to be divine and taking.
Uncover, identify, and ferret out vacation rental, real estate rentals in Bowie, and Bowie for rent by owner homes.
Distinguish and identify Estelline apartments for rent and Estelline home rentals.
Dig up and recognize holiday rentals in Upshur Texas and for rent by owner homes Upshur.
Identify and relocate Telferner United States homes for rent and vacation homes for rent by owner Telferner United States.
Notice and ascertain holiday rentals Colmesneil and rent houses Colmesneil United States.
Identify, elicit, and find Terlingua United States holiday rentals, Terlingua United States rental homes, and rent house in Terlingua United States.
Vacation homes for rent by owner Muskogee Oklahoma, Muskogee Oklahoma bed and breakfast rentals, and real estate rentals Muskogee Oklahoma
Identify, hear, and discover house rentals in Scotland United States, apartment rentals, and houses for rent in Scotland United States.
Find and recognize real estate rentals Dawson, Dawson Texas for rent by owner homes, and rental houses in Dawson Texas.
The Andrews North Texas mountain classified ads, decadent lists of marked properties, oceanfront classifieds, and loft listings for these principality can be mapped.
Conceive, debunk, and contrive house rentals Ochiltree Texas, homes for rent in Ochiltree Texas, Ochiltree Texas rent house, and real estate rentals.
Fort Worth short term rentals, rent house, Fort Worth Texas apartment rentals, and rental houses in Fort Worth
Transmigrants, entrepreneurs, and lodgers who are scanning Andrews North Texas for rent by owner homes and are trying to contrive house rentals in Andrews North Texas, Andrews North rent houses, and Andrews North Texas house rentals can look for this site, For Rent By Owner (FRBO.com) and our log classifieds, beach advertisements, waterfront directories, and mountain lists of marked properties.
Catch and find apartment rentals Louise and rental houses Louise.
See exclusive listings, exclusive classifieds, waterfront ad directories, and suburban listed properties that rental agents and landlords post on this site, FRBO.com.
Rental home Miami Beach Florida, Miami Beach Florida for rent by owner homes, vacation rentals Miami Beach Florida, and vacation homes for rent by owner in Miami Beach
Look up and identify rental properties in Joshua United States and vacation homes for rent by owner Joshua.
The Andrews North Texas ad directories particularized and particularized on FRBO.com seat loft houseboat, well appointed cottage, suburban duplex, and suburban cabin.
Perceive, design, and relocate vacation homes for rent by owner in Polk and condo rentals in Polk Texas.
You can ferret out, light upon, and conceive houses for rent in Andrews North Texas and Andrews North vacation rental.
Athens Alabama rental home and Athens bed and breakfast rentals
Devise, ascertain, and catch Terlingua vacation rentals, for rent by owner homes Terlingua United States, and Terlingua United States vacation homes.
Conceive, learn, and glimpse Alleyton United States short term rentals, houses for rent, and Alleyton United States condos for rent.
Identify, design, and hear Jack Texas rent house, vacation rentals in Jack Texas, and rental home Jack.
You can look for the well appointed lists of marked properties and well appointed ad directories under vacation rentals in Andrews North Texas, apartments for rent Andrews North Texas, and rental homes.
Andrews North land owners, brokers leasing foreclosures, and real estate investors list condo rentals in Andrews North and Andrews North Texas for rent by owner homes.
Debunk and ferret out for rent by owner homes in Deaf Smith Texas, vacation rentals in Deaf Smith Texas, Deaf Smith Texas for rent by owner homes, and Deaf Smith Texas rent house.
Vacation rentals Guilford and holiday rentals in Guilford Indiana
Elicit and observe houses for rent in Channelview United States and Channelview United States rental houses.
Holiday rentals Warren Indiana, Warren Indiana house rentals, and apartments for rent in Warren Indiana
Rent house and rental home
Andrews North Texas dope could sustain, support, stump, and sustain your pursual.
Traveling men and buddies who are wishing to find out, come upon, and learn or simply conceive information can use this webpage.
Notice, contrive, and invent the locality and approaching Andrews North Texas zone.
Our webpage does comprise novel stretch suburban and lakefront ranch, timeshare, ranch, and cottages.
Devise, move, and design vacation rental in Huntsville United States, vacation homes Huntsville, and Huntsville United States apartment rentals.
Come upon, conceive, and find vacation rental, homes for rent Ochiltree, Ochiltree Texas rent house, and house rentals in Ochiltree Texas.
Debunk, identify, and uncover condos for rent Stinnett United States, Stinnett United States rent house, and rental properties in Stinnett United States.
Invent and find houses for rent Yoakum Texas and house rentals.
Find out and elicit Stonewall Texas condos for rent and apartment rentals Stonewall.
FRBO.com can conscribe, enroll, obtain, and incorporate rustic online MLS, studio listings, lakeside indexes, and rustic classified advertisements lakefront lists of marked properties, lake ad directories, penthouse advertisements, and ski in/out ad directories to ride shotgun your Andrews North Texas travel.
Catch, explore, and determine rent houses in Fayette Texas and Fayette Texas rental houses.
Debunk and learn vacation rental, homes for rent by owner Garza, Garza Texas apartments for rent, and rental houses in Garza Texas.
|
|
