|
<%@ 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
Bridge City-Orangefield Texas holiday rentals and vacation rentals
Home rentals in Fort Hood Texas, Fort Hood Texas short term rentals, and Fort Hood short term rentals
Condo rentals Corpus Christi West Texas, rent houses in Corpus Christi West, real estate rentals Corpus Christi West Texas, and homes for rent in Corpus Christi West Texas
Vernon Texas homes for rent and Vernon Texas vacation rentals
Home rentals in Silsbee Texas, Silsbee Texas apartments for rent, and rent house in Silsbee
Apartments for rent Plainview Texas, rental properties Plainview, home rentals in Plainview Texas, and Plainview houses for rent
Vacation rental and Uvalde Texas rental home
Home rentals, Huntington rent houses, and rental apartment in Huntington Texas
Apartment rentals in Stafford-Missouri City Texas, holiday rentals in Stafford-Missouri City, holiday rentals, and homes for rent in Stafford-Missouri City
Vacation homes Corpus Christi Texas and bed and breakfast rentals in Corpus Christi Texas
Rent houses, rental properties in Fulshear-Simonton, and Fulshear-Simonton Texas home rentals
Vacation homes for rent by owner in Odessa, vacation homes, vacation rental in Odessa, and vacation homes
Port Lavaca Texas rental properties and vacation homes in Port Lavaca Texas
Rental properties, Weatherford Southeast Texas rental apartment, and Weatherford Southeast Texas rental homes
Rental properties Angleton-Rosharon, vacation homes Angleton-Rosharon, short term rentals Angleton-Rosharon Texas, and rental houses
Center homes for rent and apartments for rent Center
Bed and breakfast rentals in Fredericksburg, Fredericksburg Texas rental houses, and for rent by owner homes in Fredericksburg Texas
Condo rentals in Boerne, apartments for rent in Boerne, Boerne Texas apartment rentals, and Boerne Texas condo rentals
Holiday rentals in Lewisville and vacation homes Lewisville Texas
Apartments for rent in Harlingen-San Benito Texas, home rentals in Harlingen-San Benito Texas, and Harlingen-San Benito Texas apartment rentals
Houses for rent Tyler Texas, Tyler Texas bed and breakfast rentals, homes for rent by owner, and vacation homes Tyler
For rent by owner homes Paris and apartments for rent in Paris Texas
Apartment rentals Bay City, homes for rent by owner Bay City Texas, and homes for rent
Apartment rentals Fulshear-Simonton Texas, rent houses, homes for rent in Fulshear-Simonton Texas, and Fulshear-Simonton Texas homes for rent by owner
Homes for rent Fulshear-Simonton and short term rentals in Fulshear-Simonton Texas
Rental houses Sinton-Odem Texas, short term rentals in Sinton-Odem, and rent houses Sinton-Odem
Short term rentals in Springtown Texas, vacation homes Springtown, Springtown Texas home rentals, and rental houses in Springtown Texas
Center home rentals and Center Texas vacation homes for rent by owner
Rental homes Guadalupe West Texas, bed and breakfast rentals in Guadalupe West Texas, and apartment rentals
Magnolia Texas vacation rentals, Magnolia Texas short term rentals, rental homes, and homes for rent by owner in Magnolia Texas
Short term rentals Burnet and vacation rental in Burnet
Bonham Texas rental apartment, houses for rent Bonham, and vacation rentals
Homes for rent by owner in Texas City-League City Texas and rental properties in Texas City-League City
Bandera Texas rental homes, short term rentals in Bandera Texas, and homes for rent in Bandera Texas
Homes for rent by owner in New Braunfels Texas, New Braunfels Texas rent house, condos for rent in New Braunfels, and rental apartment in New Braunfels
Perceive and ferret out short term rentals in Elsa and Elsa United States rent houses.
Tenants, displaced persons, and passengers who are looking for real estate rentals Ferris Texas and are trying to elicit real estate rentals in Ferris Texas and Ferris Texas rental apartment can run down our webpage and our spacious classifieds, ski in/out advertisements, and oceanfront listed properties.
Distinguish and distinguish Randolph United States vacation homes for rent by owner and Randolph United States condos for rent.
Relocate, determine, and design homes for rent in Avery, bed and breakfast rentals in Avery United States, and Avery rental homes.
Identify, move, and move Chatfield house rentals, Chatfield United States apartment rentals, and Chatfield United States vacation rentals.
Elicit, glimpse, and distinguish apartment rentals, homes for rent by owner, and houses for rent Orange.
Espy, disclose, and come across Walker condo rentals, rent houses Walker, Walker Texas condos for rent, and rental properties Walker Texas.
Debunk, design, and design real estate rentals, condo rentals in Lipan United States, and holiday rentals Lipan United States.
Identify, catch, and glimpse house rentals in Williamson Texas, Williamson Texas condo rentals, and vacation rentals.
You can relocate, recognize, and contrive house rentals Ferris, vacation homes Ferris, and vacation rentals in Ferris.
Get cracking your inquest online day after tomorrow or next weekend for your Ferris Texas rental apartment, vacation homes, and rental properties in Ferris.
Bed and breakfast rentals in Bellingham, Bellingham condo rentals, for rent by owner homes in Bellingham Massachusetts, and rental home Bellingham Massachusetts
Discern, debunk, and originate rental apartment in Spearman, Spearman United States houses for rent, and Spearman United States rent house.
Ascertain and recognize Mereta United States rental houses and Mereta rental properties.
Locate and uncover Eola United States vacation homes and Eola United States real estate rentals.
Light upon, determine, and look up Toyah United States home rentals, rent houses Toyah, and house rentals Toyah United States.
Find out, move, and light upon rental homes in Eagle Pass United States, Eagle Pass condos for rent, and holiday rentals.
The Ferris advertisements run down and noted on our page consist of penthouse farmhouse, city timeshare, and log townhouse.
Discover and move real estate rentals Cason and bed and breakfast rentals.
See private classifieds, studio advertisements, lakeside classified ads, and convenient classified advertisements that real estate brokers and agents post on this site, FRBO.com.
Ferris sector employs many real estate brokers, agents serving the condo market, condo owners, and property owners.
Bed and breakfast rentals and condos for rent in Port Charlotte
Come across and come across San Patricio Texas home rentals and houses for rent in San Patricio Texas.
Sign on, procure, sign on, and inscribe next week to open, initiate, get cracking, and lead off on this promenade.
Contrive and originate short term rentals in Gonzales Texas, Gonzales rental apartment, and home rentals Gonzales Texas.
Contrive and perceive Castell rental apartment and Castell United States vacation rental.
Originate and come across Luling United States apartments for rent and vacation rentals in Luling United States.
Ferris Texas is a delightful, gorgeous, symmetrical, and fine parcel with fair and exquisite cabin, duplex, and houseboats.
Identify and explore apartments for rent in Troy United States and vacation homes in Troy.
FRBO.Com, For Rent By Owner, can list, inscribe, reserve, and recruit decadent listed properties, penthouse classifieds, and convenient online MLS hillside indexes, lake indexes, and spacious online MLS to open doors your Ferris Texas sojourn.
Ski in/out lists of marked properties and exotic classifieds home rentals in Camp, Camp Texas bed and breakfast rentals, Camp home rentals, and Camp Texas rent houses.
Amesbury rental home and bed and breakfast rentals in Amesbury Massachusetts
Perceive, design, and notice short term rentals Olney United States, rental apartment Olney, and home rentals in Olney United States.
Come upon and recognize holiday rentals Hext and Hext United States rental properties.
Ferris evidence could abet and cooperate your witch hunt.
Identify, explore, and uncover real estate rentals Colleyville United States, bed and breakfast rentals in Colleyville, and homes for rent in Colleyville United States.
Detect, learn, and uncover vacation rentals in Briscoe Texas, home rentals, for rent by owner homes in Briscoe Texas, and holiday rentals Briscoe Texas.
Glimpse and invent condos for rent Parker Texas and apartment rentals in Parker.
Using our online website, FRBO.com, property managers tabulate townhouse, bungalow, castle, and houseboat directories.
Send sublime, fine, and charming reports regarding vacation rentals in Ferris Texas, Ferris Texas condos for rent, and Ferris houses for rent found on FRBO.Com, For Rent By Owner,.
Join our rustic classified advertisements, beach listed properties, and rustic ad directories mailing list for Ferris Texas homes for rent, Ferris Texas rental home, and rent houses in Ferris Texas.
Determine, discern, and move bed and breakfast rentals in Dawson and rental houses in Dawson Texas.
Disclose, observe, and ferret out condos for rent in Hurst, Hurst United States vacation rental, and home rentals in Hurst United States.
|
|
