| Class: Listings-Listing Handling |
| How to Read: Property/Method(Parameter As Type, ...) As ReturnValue |
| Properties |
| MLSNo() As Long Purpose: Return MLS Number |
| MLSNo(MLSNumber As Long) Purpose: Set MLS Number to update a specific record |
| PropertyType() As String Purpose: Return Property Type |
| PropertyType(PropertyTypeString As String) Purpose: Set Property Type to update a specific record |
| Area() As String Purpose: Return Area |
| Area(AreaString As String) Purpose: Set Area to update a specific record |
| Price() As String Purpose: Return Sale Price |
| Price(SalePrice As String) Purpose: Set Sale Price to update a specific record |
| Address() As String Purpose: Return Property Address |
| Address(PropertyAddress As String) Purpose: Set Property Address to update a specific record |
| City() As String Purpose: Return City |
| City(PropertyCity As String) Purpose: Set City to update a specific record |
| State() As String Purpose: Return State |
| State(PropertyState As String) Purpose: Set State to update a specific record |
| Zip() As String Purpose: Return Zip |
| Zip(PropertyZip As String) Purpose: Set Zip to update a specific record |
| CurrentListing() As String Purpose: Return Current Listing ??? |
| CurrentListing(CurrentListingValue As String) Purpose: Set Current Listing to update a specific record |
| Beds() As String Purpose: Return Number of Beds |
| Beds(NumberOfBeds As String) Purpose: Set Number of Beds to update a specific record |
| Bath() As String Purpose: Return Number of Baths |
| Bath(NumberOfBaths As String) Purpose: Set Number of Baths to update a specific record |
| SqFtRange() As String Purpose: Return Sq.Ft. Range |
| SqFtRange(SqFtRangeString As String) Purpose: Set Sq.Ft. Range to update a specific record |
| LotSize() As String Purpose: Return Lot Size |
| LotSize(LotSizeValue As String) Purpose: Set Lot Size to update a specific record |
| HomeAge() As String Purpose: Return Home Age |
| HomeAge(HomeAgeInYears As String) Purpose: Set Home Age to update a specific record |
| Garage() As String Purpose: Return Garage Capacity |
| Garage(GarageCapacity As String) Purpose: Set Garage Capacity to update a specific record |
| AgentID() As String Purpose: Return Agent ID |
| AgentID(AgentRecordID As String) Purpose: Set Agent Record ID to update a specific record |
| BrokerID() As String Purpose: Return Broker ID |
| BrokerID(BrokerRecordID As String) Purpose: Set Broker Record ID to update a specific record |
| AgentID2() As String Purpose: Return Agent ID 2 |
| AgentID2(AgentRecordID2 As String) Purpose: Set Agent Record ID 2 to update a specific record |
| Acres() As String Purpose: Return Acres |
| Acres(AcresValue As String) Purpose: Set Acres to update a specific record |
| SubDivision() As String Purpose: Return Sub Division Name |
| SubDivision(SubDivisionName As String) Purpose: Set Sub Division Name to update a specific record |
| YearBuilt() As String Purpose: Return Year Built |
| YearBuilt(YearOfConstruction As String) Purpose: Set Year Built to update a specific record |
| LotLength() As String Purpose: Return Lot Length |
| LotLength(LotLengthValue As String) Purpose: Set Lot Length to update a specific record |
| LotWidth() As String Purpose: Return Lot Width |
| LotWidth(LotWidthValue As String) Purpose: Set Lot Width to update a specific record |
| IrrigationDist() As String Purpose: Return Irrigation District |
| IrrigationDist(IrrigationDistrict As String) Purpose: Set Irrigation District to update a specific record |
| SchoolDistrict() As String Purpose: Return School District Name |
| SchoolDistrict(SchoolDistrictName As String) Purpose: Set School District Name to update a specific record |
| ElemSchool() As String Purpose: Return Elementary School Name |
| ElemSchool(ElementarySchoolName As String) Purpose: Set Elementary School Name to update a specific record |
| JrHighSchool() As String Purpose: Return Jr. High School Name |
| JrHighSchool(JrHighSchoolName As String) Purpose: Set Jr. High School Name to update a specific record |
| HighSchool() As String Purpose: Return High School Name |
| HighSchool(HighSchoolName As String) Purpose: Set High School Name to update a specific record |
| Builder() As String Purpose: Return Builder |
| Builder(BuilderName As String) Purpose: Set Builder to update a specific record |
| TotalSqFtF() As String Purpose: Return Total SqFt F |
| TotalSqFtF(TotalSqFtFValue As String) Purpose: Set Total SqFt F to update a specific record |
| AboveSqFtF() As String Purpose: Return Above SqFt F |
| AboveSqFtF(AboveSqFtFValue As String) Purpose: Set Above SqFt F to update a specific record |
| BelowSqFtF() As String Purpose: Return Below SqFt F |
| BelowSqFtF(BelowSqFtFValue As String) Purpose: Set Below SqFt F to update a specific record |
| TotalSqFtUn() As String Purpose: Return Total SqFt Un |
| TotalSqFtUn(TotalSqFtUnValue As String) Purpose: Set Total SqFt Un to update a specific record |
| AboveSqFtUn() As String Purpose: Return Approx. SqFt. |
| AboveSqFtUn(AboveSqFtUnValue As String) Purpose: Set Approx. SqFt. to update a specific record |
| BelowSqFtUn() As String Purpose: Return Below SqFt Un |
| BelowSqFtUn(BelowSqFtUnValue As String) Purpose: Set Below SqFt Un to update a specific record |
| TotalFun() As String Purpose: Return Total Fun |
| TotalFun(TotalFunValue As String) Purpose: Set Total Fun to update a specific record |
| AirCond() As String Purpose: Return Air Conditioning |
| AirCond(AirConditioning As String) Purpose: Set Air Conditioning to update a specific record |
| ConstType() As String Purpose: Return Construction Type |
| ConstType(ConstructionType As String) Purpose: Set Construction Type to update a specific record |
| Fireplaces() As String Purpose: Return Fireplaces |
| Fireplaces(FireplaceString As String) Purpose: Set Fireplaces to update a specific record |
| GarageType() As String Purpose: Return Garage Type |
| GarageType(GarageTypeString As String) Purpose: Set Garage Type to update a specific record |
| HeatingType() As String Purpose: Return Heating Type |
| HeatingType(HeatingTypeString As String) Purpose: Set Heating Type to update a specific record |
| KitchenFeatures() As String Purpose: Return Kitchen Features |
| KitchenFeatures(KitchenFeaturesString As String) Purpose: Set Kitchen Features to update a specific record |
| LawnFeatures() As String Purpose: Return Lawn Features |
| LawnFeatures(LawnFeaturesString As String) Purpose: Set Lawn Features to update a specific record |
| LotFeatures() As String Purpose: Return Lot Features |
| LotFeatures(LotFeaturesString As String) Purpose: Set Lot Features to update a specific record |
| PoolSpa() As String Purpose: Return Pool/Spa |
| PoolSpa(PoolSpaString As String) Purpose: Set Pool/Spa to update a specific record |
| RoofType() As String Purpose: Return Roof Type |
| RoofType(RoofingType As String) Purpose: Set Roof Type to update a specific record |
| Sewer() As String Purpose: Return Sewer |
| Sewer(SewerString As String) Purpose: Set Sewer to update a specific record |
| StructureFeatures() As String Purpose: Return Structure Features |
| StructureFeatures(StructureFeaturesString As String) Purpose: Set Structure Features to update a specific record |
| Comments() As String Purpose: Return Comments |
| Comments(ListingComments As String) Purpose: Set Comments to update a specific record |
| SetArea(Area As String) Purpose: Set Area for listing search |
| SetZip(ZipCode As String) Purpose: Set Zip Code for listing search |
| SetPropertyType(PropertyType As String) Purpose: Set Property Type for listing search |
| SetAge(Age As String) Purpose: Set Age for listing search |
| SetMinPrice(MinimumPrice As String) Purpose: Set Minimum Price for listing search |
| SetMaxPrice(MaximumPrice As String) Purpose: Set Sale Maximum Price for listing search |
| SetMinSqFt(MinimumSqFt As String) Purpose: Set Minimum SqFt for listing search |
| SetMaxSqFt(MaxSqFt As String) Purpose: Set Maximum SqFt for listing search |
| SetBeds(NumberOfBeds As String) Purpose: Set Number of Beds for listing search |
| SetBaths(NumberOfBaths As String) Purpose: Set Number of Baths for listing search |
| SetGarage(GarageCapacity As String) Purpose: Set Garage Capacity for listing search |
| SetElemSchool(ElementarySchool As String) Purpose: Set Approx SqFt for listing search |
| SetJrHighSchool(JrHighSchool As String) Purpose: Set Jr. High School for listing search |
| SetHighSchool(HighSchool As String) Purpose: Set High School for listing search |
| SetHasImage(TrueFalse As Boolean) Purpose: Set to check if listing has Images |
| SetImagePath(PictureFilePath As String) Purpose: Set to check if listing has Images |
| ListingIndex() As Integer Purpose: Return current Listing Index |
| ListingCount() As Integer Purpose: Return Listing Count after calling GetListings() |
| ListingOffset() As Integer Purpose: Return Listing Offset after calling GetListings() |
| ListingOffsetEnd() As Integer Purpose: Return Listing Offset End after calling GetListings() |
| ListingEnd() As Boolean Purpose: Used with GetListings() and NextListing() |
| SearchTotalCount() As Integer Purpose: Return Total Count of Records found after calling GetListings() |
| Methods |
| GetListingByMLS(MLSNumber As Long) As Boolean Purpose: Search DB for record that contain MLS Number in 'mls_no' field Requires: MLS Number Returns: True - successful; False - error or no records were found |
| GetListings(Offset As Integer, Length As Integer) As Boolean Purpose: Search DB for records that contain MLS Number in 'mls_no' field Use ListingByIndex() to retrieve records by Index [ 1 to ListingCount() ] Requires: MLS Number Returns: True - successful; False - error or no records were found |
| NextListing() Purpose: Return data for next Listing found |
| ListingByIndex(Index As Integer) As Boolean Purpose: Return Listing data for a given Index after calling GetListings() Requires: Index - number between 1 and ListingCount() Returns: True - successful; False - error |
| ResetListingVars() Purpose: Reset all Listing variables |
| ResetSearchVars() Purpose: Reset all MLS variables |